Extract Latest date records

Question

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 2a11-12-2024 15:45a15-12-2024 04:31a15-12-2024 04:32

martinson · Accepted Answer

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 · Accepted Answer

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

nagakavyasri · Accepted Answer

@sakshim Try Sample tool after sorting with date

Gaurav_Dhama_ · Accepted Answer

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 · Accepted Answer

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