I'm working on ArcMap, and I have a one to many relation between a building column and the residents in the building.

The attribute table for the building has these columns: id,label,number.

I have an excel sheet containing these columns: number,resident

I'm trying to relate the number from building attribute table and the number in the excel sheet.

How to do that?

migrated from stackoverflow.com Aug 27 '14 at 9:27

This question came from our site for professional and enthusiast programmers.


As mentioned by @brichins in a comment there is ArcGIS documentation entitled "About joining and relating tables" which provides an excellent introduction and tips like:

When using data where a one-to-many or many-to-many relationship exists, you should use a relate or relationship class to establish the relationship between the datasets.

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.