AnsweredAssumed Answered

How does ArcMAP eliminate duplicates when joining tables?

Question asked by slewisgo on Sep 12, 2014
Latest reply on Mar 30, 2015 by geospanproduction

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.