Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Removing duplicate but keep most recent edited

Highlighted
8 - Asteroid

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

14 - Magnetar
14 - Magnetar

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!

Highlighted
8 - Asteroid

Thanks so much!! @Kenda 

Labels