Hello Team @atcodedog05 , Please refer to this sample dataset from my overall data Last Modified ByLastModifiedDateCompanyJack09.12.2020 07:46ABC TechJack11.12.2020 14:35ABC TechPeter21.12.2020 06:15FDE AutoWinson30.10.2020 12:15HIC FensterBlake30.10.2020 12:15IRT IronWinson14.12.2020 10:11HIC 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 ByLastModifiedDateCompanyJack11.12.2020 14:35ABC TechPeter21.12.2020 06:15FDE AutoBlake30.10.2020 12:15IRT IronWinson14.12.2020 10:11HIC Fenster Can you please advise with how this can be achieved in Alteryx. Thanks

Max Record based on Date

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

Datasets

Developer Tools

Common Use Cases

Accepted answers

Emil_Kos

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.

Grouping 3.yxmd

All comments

Kenda

Hi @JDong

Try first sorting your data by Last Modified By then by LastModifiedDate. From there, use the sample tool to keep the last record, grouping by the Last Modified By field.

Note - you may have to edit your date field first so that it is in the Alteryx date format.

Hope this helps!

JDong

@Kenda

Thanks this is helpful.

In my actual dataset I have derived close to 40 columns, so the grouping is not happening on all columns. Also the date now shows same for all rows of data.

Will it help if I add a summerize tool after the Sample tool ?

Thanks

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335