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.
Solved! Go to 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