Choosing latest date and by ID

[SH_94]

Dear community,

I have the data set as below and would like to ask how can we use alteryx to choose the latest date for each ID as per screenshot below:

I have also attached the excel file below for your reference.

Thank you.

[TheOC · Accepted solution]

hi @SH_94 

This should work for you:
Convert dates to datetime

Summarize group by ID, max Date:

The output is slightly off in the example due to the output fields being in your example workflow, but you can see for the input it has worked as expected:

Please find attached.

Cheers,
TheOC

[binuacs]

@SH_94