Free Trial

Alteryx Designer Desktop Discussions

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

Extract Latest date records

sakshim
8 - Asteroid

Hi, I have a dataset which has duplicates records, the only field which differentiates them is the latest date and time . Now, ask is to get latest record , I tried sorting and then fetching Unique but it is not picking up latest date.

 

Field 1Field 2
a11-12-2024 15:45
a15-12-2024 04:31
a15-12-2024 04:32
6 REPLIES 6
martinson
10 - Fireball

Using a summarize tool will give you the latest date if the data is sorted appropriately. Please let me know if that solves your issue.

 

 

 

Christina_H
14 - Magnetar

Unique will always take the first record for each ID.  Try reversing your sort order.

nagakavyasri
12 - Quasar

@sakshim Try Sample tool after sorting with date

 

Screenshot 2024-12-23 170601.png

Gaurav_Dhama_
9 - Comet

Use summarise to pick the latest date for each data line (add the parameters in group by).

Use this to join back to your original data to pick the remaining data. Unless you have all the data already after using summarise.

Qiu
21 - Polaris
21 - Polaris

We can Unique Tool with Sorting, Summarize, or Sample tools with Sorting, nice approaches. 

sakshim
8 - Asteroid

New Year Wishes to all. Thank you so much for all your responses. It is of great help also for my other doubt as well.

Labels
Top Solution Authors