Removing duplicate but keep most recent edited

[nwatzlaf]

Hi there,

I have a data set with some duplicates. I want to keep the one row where the "last edit date" is the most recent. Is there a way to do this?

Thanks,

Natalia

[Kenda · Accepted solution]

Hi @nwatzlaf 

The sort tool will be your friend here. I'd recommend sorting by your "Last Edit Date" field in Descending order. Then you can either use a Sample or Unique tool to get the first one for each group of records. 

Hope this helps!

[nwatzlaf]

Thanks so much!! @Kenda