How does ArcMAP eliminate duplicates when joining tables?

09-12-2014 06:51 AM
New Contributor

I have several excel tables with a large amount of data that I have narrowed down to FIPS_CODE and the ag production data in order to join them to a county level shapefile. The tables have duplicate values for each county, when I join the duplicates are no longer there.

My question is, when ArcMAP decides to eliminate duplicates, such as in this case, how does it do it?

- Median? (which would be ideal since this is what I needed to do anyway)

- Average?

- First occurrence?


Any help would be great, thanks.

0 Kudos
1 Reply
Occasional Contributor II

Did you come across this About joining and relating tables—Help | ArcGIS for Desktop ? I see you asked about this a while ago, so I am guessing you have found the answer by now.

0 Kudos