I have two shape files (e.g. postal code areas and cities) which I want to join based on an id that both shape files have in common (the id would be the city name in this example). Joining the two tables is not the problem (via Join and selecting the city name as field on which the join is based).
But what I really want is an enumeration of all the postal codes of a city - if I join them and take cities with postal codes, every city will get one random postal code that has the same city name as the city, but I want all of them as comma-separated list as new attribute in the cities shape file).
Is there a way to do that?
Example table postal codes:
Postal Code | City 0 | A-Town 1 | A-Town 2 | A-Town 3 | B-Town 4 | B-Town 5 | C-Town
Example cities table:
City Name A-Town B-Town C-Town
Desired outcome table:
City Name | Postal codes A-Town | 0, 1, 2 B-Town | 3, 4 C-Town | 5