I have a point feature class with 5,000 records. Each record has a unique ID, 4260, 3004, 5465, etc...
There are duplicate records of each point. This means I have 2 points stacked on top of one another.
I need to separate each group of duplicate records into a new point feature class.
In the below screenshot, you see the ADDR_KEY field. I want to extract the 1st duplicate record into a new point feature class, then the 2nd duplicate record in a new feature class. The goal is to have each new point feature class contain no duplicate records. Any suggestions on how this can be done?
To illustrate further,
New Point Feature Class 1 will include the first value of 3460, 3470, 3473, and 3475.
New Point Feature Class 2 will include the second value of 3460, 3470, 3473, and 3475.
Solved! Go to Solution.
You can try the following:
1. Use Summary Statistics tool with the ADDR_KEY as the Case Field and specify OBJECTID and FIRST for the Statistics Fields as shown below. The output is a table, say outStat, which contains a FIRST_OBJECTID field with the original, first OBJECTID values from every unique ADDR_KEY value.
2. Use Join Field tool to transfer the FIRST_OBJECTID field from the outStat to your point feature class table via OBJECTID_1* and FIRST_OBJECTID as the join fields of the two tables.
Now your point feature class should have the transferred FIRST_OBJECTID with values for the first point of each pair of unique ADDR_KEY. You should have "Null" for the second point of each pair. You should be able to select them separately and use Copy Features to put them into new feature classes.
Hello Dan,
Yes, I tried Find Identical, it found the identical records, but the question is how do extract and separate them into two new tables or feature classes. I tried relate (one to one), and the Find Identical export table matches all the dups, not just one of them in the pair of dups.
You can try the following:
1. Use Summary Statistics tool with the ADDR_KEY as the Case Field and specify OBJECTID and FIRST for the Statistics Fields as shown below. The output is a table, say outStat, which contains a FIRST_OBJECTID field with the original, first OBJECTID values from every unique ADDR_KEY value.
2. Use Join Field tool to transfer the FIRST_OBJECTID field from the outStat to your point feature class table via OBJECTID_1* and FIRST_OBJECTID as the join fields of the two tables.
Now your point feature class should have the transferred FIRST_OBJECTID with values for the first point of each pair of unique ADDR_KEY. You should have "Null" for the second point of each pair. You should be able to select them separately and use Copy Features to put them into new feature classes.
Thank you, Dan! so helpful. Exactly what I needed to solve this conundrum.
You are welcome, Tim. Enjoy geoprocessing 🙂