Find greatest value for each specific ID

jrtomici

Hi,

I have a dataset like this:

ID    Value
1     5
1     6
1     7
2     23
2     24
2     25

I want to write a ETL formula that creates a third column saying the greatest value for each ID is:

ID    Value    Greatest
1     5        7
1     6        7
1     7        7
2     23       25
2     24       25
2     25       25

Thank you

trafalger

Or do a group by ID, find the greatest value and join it back on.