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.
