How to get the value based on Max date

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

Best Practices

Data Investigation

Demographic Analysis

Accepted answers

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.

All comments

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

Hello @Niru ,

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

Regards

max values.yxmd

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.

@Emil_Kos thank you, i got the expected output.

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

Thanks you very much, 88 value is missing from output

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703