Group a column and retain min date row only

[Saravanan13]

Hello,

I want to group column "ID" and retains only rows which has min date as shown in output. Can anyone assist on this

Input

Account	ID	date	branch	status	Country
1234566	100	4/20/2024	ABC	Suspend	USA
1234567	100	4/15/2000	CDE	Cancel	USA
1234570	100	4/26/2022	FGH	Cancel	USA
1234561	100	4/26/2001	IJK	Cancel	USA
789	200	4/26/2024	FADAS	Cancel	UK
789	200	4/26/2024	ASDFA	Complete	UK
789	200	4/20/2023	ERGQ	Complete	UK
789	200	4/26/2022	FAAFD	Complete	UK

Output

Account	ID	date	branch	status	Country
1234567	100	4/15/2000	CDE	Cancel	USA
789	200	4/26/2022	FAAFD	Complete	UK

[alexnajm · Accepted solution]

Here you go!

[binuacs]

@Saravanan13 One way of doing this

[usmanbashir]

@Saravanan13 - Please see attached workflow. I like using a sort then unique tool in use cases like these. Unique tool always takes the first record of the selected unique column field. Hope this helps!

[aatalai]

similar to @usmanbashir but using sample tool instead of unique

[Saravanan13]

Thank you it worked

[alexnajm]

Happy to help!