I have 2 files and I merged them together into one file-geodatabase feature class. I want to remove entries from File1, Column C, that also appear in File2, ColumnD. I attempted to use the geoprocessing tool DeleteIdentical but it deletes from EITHER File1 or File2 (aka Column C or Column D). I need to specify that only rows from File1 (Column C) should be deleted. I can distinguish in the merged File1_2_Merge which column belongs to which file. I am using ArcGIS 10.2 Desktop. All 3 files are file-geodatabase feature classes.
I would eliminate the duplication before the merge, then address this in a couple of steps.
- Join File2 to File1 (Right-click File1 in the table of contents, choose Joins and Relates/ Join, Join attributes from a table. Base the join on Column C. The table to join to this layer will be File2, and the field to base the join on will be Column D. Choose Keep all records. This will retain File1 as-is but also include a new column to represent File2.)
- Select features from File1 where Column D is not null (these will be the rows where Column C and Column D match, so, your duplicate rows).
- Delete your selection from File1.
- Remove the join from File1 (Right-click File1 in the table of contents, choose Joins and Relates/ Remove Join(s) and remove the File2 join).
- Then re-merge Files 1 & 2, if so desired.