Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Filter duplicate values by latest date

RDF25087
8 - Asteroid

Help!

 

I have a dataset that contains duplicated serial numbers:

 

Registered DateSerial Number
08/11/20231234
06/11/20231234
06/11/20231234
14/11/20237890
17/11/20237890

 

I need to only keep the rows with the latest registered date. So for the above example, I'd like the data cleansed to extract only the following:

 

Registered DateSerial Number
08/11/20231234
17/11/20237890

 

Any help would be greatly appreciated.

 

Thanks

RDF

2 REPLIES 2
alexnajm
18 - Pollux
18 - Pollux

Sounds like a Summarize tool!

TimN
13 - Pulsar

Just sort and then use a unique tool...

 

Note date sorted in descending order

Labels
Top Solution Authors