I am trying to join an excel file with a shapefile based on a zipcode. My problem is that I have multiple persons with the same zip code, but it joins only 1 of those persons.

Is it possible to automatically add multiple points when trying to join several persons from the excel file with my shapefile (which only has one zip code point)?


Here is a simple workaround, (but of course it would be cleaner to do it with an insertcursor in Python).

1) Add the X andd Y coordinates for your points (from field calculator, or with the tool in Data management > features)

2) join the table of your point on your excel file

3) export the excel file to another table, and add it as point using "Make XY event layer"


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.