topic How does ArcMAP eliminate duplicates when joining tables? in Data Management Questions https://community.esri.com/t5/data-management-questions/how-does-arcmap-eliminate-duplicates-when-joining/m-p/325602#M18620 <HTML><HEAD></HEAD><BODY><P>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.</P><P>My question is, when ArcMAP decides to eliminate duplicates, such as in this case, how does it do it?</P><P>- Median? (which would be ideal since this is what I needed to do anyway)</P><P>- Average?</P><P>- First occurrence?</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Any help would be great, thanks.</P></BODY></HTML> Fri, 12 Sep 2014 13:51:34 GMT SarahLewis-Gonzales 2014-09-12T13:51:34Z How does ArcMAP eliminate duplicates when joining tables? https://community.esri.com/t5/data-management-questions/how-does-arcmap-eliminate-duplicates-when-joining/m-p/325602#M18620 <HTML><HEAD></HEAD><BODY><P>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.</P><P>My question is, when ArcMAP decides to eliminate duplicates, such as in this case, how does it do it?</P><P>- Median? (which would be ideal since this is what I needed to do anyway)</P><P>- Average?</P><P>- First occurrence?</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Any help would be great, thanks.</P></BODY></HTML> Fri, 12 Sep 2014 13:51:34 GMT https://community.esri.com/t5/data-management-questions/how-does-arcmap-eliminate-duplicates-when-joining/m-p/325602#M18620 SarahLewis-Gonzales 2014-09-12T13:51:34Z Re: How does ArcMAP eliminate duplicates when joining tables? https://community.esri.com/t5/data-management-questions/how-does-arcmap-eliminate-duplicates-when-joining/m-p/325603#M18621 <HTML><HEAD></HEAD><BODY><P>Did you come across this <A href="http://desktop.arcgis.com/en/desktop/latest/manage-data/tables/about-joining-and-relating-tables.htm" title="http://desktop.arcgis.com/en/desktop/latest/manage-data/tables/about-joining-and-relating-tables.htm">About joining and relating tables—Help | ArcGIS for Desktop</A> ? I see you asked about this a while ago, so I am guessing you have found the answer by now.</P></BODY></HTML> Mon, 30 Mar 2015 14:47:47 GMT https://community.esri.com/t5/data-management-questions/how-does-arcmap-eliminate-duplicates-when-joining/m-p/325603#M18621 LisaTurner 2015-03-30T14:47:47Z