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 AccountIDdatebranchstatusCountry12345661004/20/2024ABCSuspendUSA12345671004/15/2000CDECancelUSA12345701004/26/2022FGHCancelUSA12345611004/26/2001IJKCancelUSA7892004/26/2024FADASCancelUK7892004/26/2024ASDFACompleteUK7892004/20/2023ERGQCompleteUK7892004/26/2022FAAFDCompleteUK Output AccountIDdatebranchstatusCountry12345671004/15/2000CDECancelUSA7892004/26/2022FAAFDCompleteUK

Group a column and retain min date row only

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

Data Investigation

Accepted answers

alexnajm

Here you go!

Group a column and retain min date row only.yxmd

All comments

alexnajm

Here you go!

Group a column and retain min date row only.yxmd

binu_acs

@Saravanan13 One way of doing this

Summarize_25042024.yxmd

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!

GroupColumn_RetainMinDate.yxmd

aatalai

similar to @usmanbashir but using sample tool instead of unique

Group a column and retain min date row only.yxmd

Saravanan13

Thank you it worked

alexnajm

Happy to help!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703