How to get Maximum of the date, when the dates are in same column

[Sanjana_HS]

Hi,

Can someone help how to get later of the date when the dates are in same column.

What i need: If ID=ID then pick late date from Date column, attached example below:
Output: for Zyx need new date coloumn to show 6/22/2023 for abc need 2/7/2023 as new date

	ID	Name		Visa	Date
Visa by Fragomen - 9.22.23	1234	zyx	[Null]	ESTA	6/22/2023
Visa by Fragomen - 9.22.23	1234	zyx	[Null]	J-1	5/22/2023
Visa list by Susan - 8.1.23	7890	abc	null	B-1	1/6/2023
Visa by Fragomen - 9.22.23	7890	abc	[Null]	B-1	2/7/2023	2/7/2023

[DataNath · Accepted solution]

Hey @Sanjana_HS here's one way I can think of doing it - just some date formatting so Alteryx can worth with your values and then conducting a join based on when we take the Max for each ID, followed by some clean up of fields:

[Qiu · Accepted solution]

@Sanjana_HS 
We can do a sort, even not converting it to Date format, the easiest way is to use Multi-row tool. 😁