nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Delete duplicates and keep latest record (MAX ObjectID)

REDARiahi

I have a dataset with daily COVID-19 data for the countries of the Americas since the beginning of the pandemic. I have many duplicated records (same ISO3_CODE and Report_Date) and I want to keep the most recent record for each. Ideally, I would like to this with ModelBuilder, if possible.

I tried DELETE IDENTICAL tool, but unfortunately it keeps the first duplicate and deletes the others. I want the exact opposite: Keep the last duplicate (MAX Object ID) and delete the previous ones.

Any suggestions?

Vind meer berichten getagd met

Accepted answers

JayantaPoddar

I hope you have used the Sort Geoprocessing tool.

After sorting the features in descending order of ObjectID, the latest feature should be having the lowest ObjectID in the newly created feature class.

That was my idea.

All comments

REDARiahi

It finally worked! Thank you Felix and Jayanta

FelixPertziger

Join it back to original. Delete records that don't match.

REDARiahi

Thanks for tip.

However, I'm still having issue deleting the duplicates.
SORT can't use ObjectID as sorting field. I had to ADD FIELD (ObjID), then assign it ObjectID value. After that, I was able to SORT using ObjID. However, when using DELETE IDENTICAL on the sorted feature layer, it deletes the rows from the sorted table, not the feature layer itself...

Is there an efficient way to apply the sorting to the original feature layer?

JayantaPoddar

I hope you have used the Sort Geoprocessing tool.

After sorting the features in descending order of ObjectID, the latest feature should be having the lowest ObjectID in the newly created feature class.

That was my idea.

REDARiahi

Unfortunately, that didn't work. It still keeps the lowest (MIN) ObjectID.

JayantaPoddar

First, you could Sort by ObjectID field in descending. Then try doing a Delete Identical.

You could add them in a Model Builder, and create a model.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.