AnsweredAssumed Answered

How do I filter a postcode dataset to find a subset of data from a specific set of postcodes in an excel

Question asked by penjie23 on Jul 28, 2017
Latest reply on Jul 28, 2017 by xander_bakker

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.

 

Thanks

Outcomes