topic How do I filter a postcode dataset to find a subset of data from a specific set of postcodes in an excel in New to GIS Questions https://community.esri.com/t5/new-to-gis-questions/how-do-i-filter-a-postcode-dataset-to-find-a/m-p/694482#M1845 <HTML><HEAD></HEAD><BODY><P>Hi, so I have a full post/zipcode dataset of over 1,000,000 features. However I want to filter out and consider only about 1500 of them. These postcodes have no common attribute but the exact postcode is in both the attribute table for the full dataset shapefile and in a column of the excel table. Could it be done by adding a column to the excel table populated with a one, attribute joining the table to the shapefile then filtering the shapefile by the 'one' attribute. Then I could create a new layer based on the selection? Not exaclty sure that would work, but if anyone has a solution or tweaks it would be much appreciated.</P><P></P><P>Thanks</P></BODY></HTML> Fri, 28 Jul 2017 11:21:01 GMT EllenWildig 2017-07-28T11:21:01Z How do I filter a postcode dataset to find a subset of data from a specific set of postcodes in an excel https://community.esri.com/t5/new-to-gis-questions/how-do-i-filter-a-postcode-dataset-to-find-a/m-p/694482#M1845 <HTML><HEAD></HEAD><BODY><P>Hi, so I have a full post/zipcode dataset of over 1,000,000 features. However I want to filter out and consider only about 1500 of them. These postcodes have no common attribute but the exact postcode is in both the attribute table for the full dataset shapefile and in a column of the excel table. Could it be done by adding a column to the excel table populated with a one, attribute joining the table to the shapefile then filtering the shapefile by the 'one' attribute. Then I could create a new layer based on the selection? Not exaclty sure that would work, but if anyone has a solution or tweaks it would be much appreciated.</P><P></P><P>Thanks</P></BODY></HTML> Fri, 28 Jul 2017 11:21:01 GMT https://community.esri.com/t5/new-to-gis-questions/how-do-i-filter-a-postcode-dataset-to-find-a/m-p/694482#M1845 EllenWildig 2017-07-28T11:21:01Z Re: How do I filter a postcode dataset to find a subset of data from a specific set of postcodes in an excel https://community.esri.com/t5/new-to-gis-questions/how-do-i-filter-a-postcode-dataset-to-find-a/m-p/694483#M1846 <HTML><HEAD></HEAD><BODY><P>Maybe you should export the Excel table to a ArcGIS format (like a FileGeodatabase table, see <A class="link-titled" href="https://pro.arcgis.com/en/pro-app/tool-reference/conversion/excel-to-table.htm" title="https://pro.arcgis.com/en/pro-app/tool-reference/conversion/excel-to-table.htm">Excel To Table—Conversion toolbox | ArcGIS Desktop</A>&nbsp;),&nbsp;define a relate (see&nbsp;<A class="link-titled" href="https://pro.arcgis.com/en/pro-app/tool-reference/data-management/add-relate.htm" title="https://pro.arcgis.com/en/pro-app/tool-reference/data-management/add-relate.htm">Add Relate—Data Management toolbox | ArcGIS Desktop</A>&nbsp;) between the ZIP code features and the list of ZIP code you want to use, select the features in the table with the ZIP code to use and propagate the selecting into the ZIP code features (<A class="link-titled" href="https://pro.arcgis.com/en/pro-app/help/data/tables/view-related-data.htm" title="https://pro.arcgis.com/en/pro-app/help/data/tables/view-related-data.htm">View related data—ArcGIS Pro | ArcGIS Desktop</A>&nbsp;) and export the selection.</P></BODY></HTML> Fri, 28 Jul 2017 19:05:17 GMT https://community.esri.com/t5/new-to-gis-questions/how-do-i-filter-a-postcode-dataset-to-find-a/m-p/694483#M1846 XanderBakker 2017-07-28T19:05:17Z