Hello again! I'm trying to find the duplicates in one shapefile using the Intersect tool. It works great, but I'd love to know how to get it to tell me WHICH unique ID is the one that it intersects with. The selected features in the picture are the ones that are duplicates, but I'm not sure how to transfer over to Excel so I can show which ID is the duplicate.
I'd like my final example to look like this:
UniqueID Duplicate Value ID Duplicate Value ID 2
9216 9366 9490
Really, I'd only need the first duplicate value returned if that's easier. Anyone know how to accomplish this? Thanks so much!
Do you have an advanced license?
Find Identical—Data Management toolbox | Documentation
I do. I think Spatial Join solved my problem, but I'm going to try the find identical as well. Thank you!
Hi Lindsey Winn,
Unfortunately there isn't one distinct id that intersect as they are all overlappying by the sounds of it.
As Dan mentioned you could use the Find Identical, and if you want to remove the duplicates you can use the Delete Identical tool.
Thank you! Good idea, I'll try this!