AnsweredAssumed Answered

Export of a joined table results in more features than you start with

Question asked by geonetadmin on Nov 29, 2012
Latest reply on Feb 11, 2014 by rfairhur24
Original User: seckhardt

In ArcGIS 10.1 my export of a joined table has more records than the original feature class from which it came.  It took me a bit to figure out but it looks like if you have a duplicate in the field in which you are joining to, say a table for instance, the export feature class of the joined data will create a duplicate polygon in your feature class.  

For instance, let�??s say you have a polygon feature class with just 1 record and you join this data to a table of 5 records that is a duplicate of each in the join field you are using.  After the join you still have 1 record in your feature class table. However, I'm finding that when you export the joined data, I'm now left with a feature class containing 5 records where it made a duplicate polygon to match the number of records in the table.

I can't see why this would be intentional and is definitely not the output you get prior to ArcGIS 10.

Attachments

Outcomes