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.

trafalger

I'd use the Rank and Window Tile

https://domohelp.domo.com/hc/en-us/articles/360042922814-Old-Magic-ETL-Tiles-Rank-and-Window

and then partition by your ID.

trafalger

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

jaeW_at_Onyx

+1 @trafalger window function max() would be good except the window doesn't have an unlimited end of window.

so group by would be the best.