How to get the value based on Max date

[Niru]

Hello All,

how to get the latest updated value from based on Max Date, kindly help me

ID	Value	Date
101435	98.82	1/8/2021 14:13
101435	99	1/9/2021 14:13
101435	100	1/10/2021 14:13
101436	100	1/8/2021 14:13
101436	88	1/10/2021 14:13
101436	100	1/8/2021 14:13
115564	96	1/13/2021 10:16
115564	98.44	1/12/2021 10:16
116545	100	1/12/2021 11:16
116545	99.22	1/14/2021 10:16

Expected output:

ID	Value	Date
101435	100	1/10/2021 14:13
101436	88	1/10/2021 14:13
115564	96	1/13/2021 10:16
116545	99.22	1/14/2021 11:16

Thanks

Niru

[Jean-Balteryx]

Hi @Niru ,

Here is a workflow including the logic. The goal is to sort your dates for each ID then pick the first one.

Also your date field needs to be converted to Date Type.

Cheers,

Jean-Baptiste

[afv2688]

Hello @Niru ,

You can achieve this with a summarize and join tool easily 🙂

Regards

[Emil_Kos · Accepted solution]

Hi @Niru,

I have preared a workflow for you:

The output:

Just to let you know there is a max value in the summarize tool. This option is very handy in a situation like this. 

[Niru]

@Emil_Kos  thank you, i got the expected output. 

[Niru]

@Jean-Balteryx Thanks for your reply, 88 value is missing from output

[Niru]

@afv2688 

Thanks you very much, 88 value is missing from output

[Jean-Balteryx]

@Niru, I get the 88 in my output. Did you apply well the group by option of the Sample Tool ?