Max Record based on Date

[JDong]

Hello Team @atcodedog05 ,

Please refer to this sample dataset from my overall data

Last Modified By	LastModifiedDate	Company
Jack	09.12.2020 07:46	ABC Tech
Jack	11.12.2020 14:35	ABC Tech
Peter	21.12.2020 06:15	FDE Auto
Winson	30.10.2020 12:15	HIC Fenster
Blake	30.10.2020 12:15	IRT Iron
Winson	14.12.2020 10:11	HIC Fenster

I need to retreive one line of record and group the records based on max of modified date

So end result in this case would be 

Last Modified By	LastModifiedDate	Company
Jack	11.12.2020 14:35	ABC Tech
Peter	21.12.2020 06:15	FDE Auto
Blake	30.10.2020 12:15	IRT Iron
Winson	14.12.2020 10:11	HIC Fenster

Can you please advise with how this can be achieved in Alteryx.

Thanks

[JDong]

Hi @Emil_Kos 

Please refer to the below extended data source

Last Modified By	Last Modified Date	Company	Owner	Modifier
Jack	09.12.2020 07:46	ABC Tech	ABC	Apple
Jack	09.12.2020 07:52	ABC Tech	ABC	Adam
Peter	21.12.2020 06:15	FDE Auto	ABC	Nokia
Winson	14.12.2020 12:15	HIC Fenster	DEF	Samsung
Blake	30.10.2020 12:15	IRT Iron	DEF	Turtle
Winson	14.12.2020 10:11	HIC Fenster	GHI	Siego
Blake	30.10.2020 12:13	IRT Iron	GHI	Demir

When I see these additional columns and still the output needs to be on max date and time.

Please note the updates colored.

Thanks

[Emil_Kos]

Hi @JDong,

I would use summarize in order to show max time and company name. Afterwards, I would join the data with the data set.

It is really easy and it should work for your big multiple column file. 

[JDong]

@Emil_Kos 

In my use case there are multiple owner names for every company and hence it is not grouping I guess ?

It still shows multiple rows and surely different values for owner column. Is there a way to ensure based on modified date to pick the corresponding owner and modifier.

Thanks

[Emil_Kos · Accepted solution]

Hi @JDong,

This solution will work for you. You just need to pick columns that you think they are final. 

If you still have problems provide a bigger data set with expected output and someone will definitely help you.