https://community.esri.com/t5/arcgis-pro-questions/removing-unwanted-values/m-p/1329663#M73174 <P>Context:</P><P>We were given an excel file that has the PID (property ID) numbers of all the parcels of land that need to be mapped. We have a shapefile that includes the 300 or so parcels of land in it and each one i labeled with the proper PID, but it also includes another 1000 or so that we do not need.</P><P>How do we separate the features with the PIDs we want, from the features we don't want?&nbsp;&nbsp;</P> Mon, 18 Sep 2023 15:49:53 GMT AidenHay 2023-09-18T15:49:53Z https://community.esri.com/t5/arcgis-pro-questions/removing-unwanted-values/m-p/1329663#M73174 <P>Context:</P><P>We were given an excel file that has the PID (property ID) numbers of all the parcels of land that need to be mapped. We have a shapefile that includes the 300 or so parcels of land in it and each one i labeled with the proper PID, but it also includes another 1000 or so that we do not need.</P><P>How do we separate the features with the PIDs we want, from the features we don't want?&nbsp;&nbsp;</P> Mon, 18 Sep 2023 15:49:53 GMT https://community.esri.com/t5/arcgis-pro-questions/removing-unwanted-values/m-p/1329663#M73174 AidenHay 2023-09-18T15:49:53Z https://community.esri.com/t5/arcgis-pro-questions/removing-unwanted-values/m-p/1329679#M73175 <P>Joins are accomplished using these tools</P><P><A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-join.htm" target="_blank">Add Join (Data Management)—ArcGIS Pro | Documentation</A></P><P><A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/join-field.htm" target="_blank">Join Field (Data Management)—ArcGIS Pro | Documentation</A></P><P>does neither with all their options suit?</P> Mon, 18 Sep 2023 16:14:00 GMT https://community.esri.com/t5/arcgis-pro-questions/removing-unwanted-values/m-p/1329679#M73175 DanPatterson 2023-09-18T16:14:00Z