Max value from a column

[william_fu]

  How can I calculate the desired Max(Step) column in the script?

ID	Step	Max(Step)
519623	1	1
520317	1	2
520317	2	2
521853	1	1
523273	1	3
523273	2	3
523273	3	3

I tried with FieldValue, but this gives me the overall max instead of the max by ID:

Left Join ([table])

LOAD Max(FieldValue('Step', recno()))) as MaxStep

Resident

;

[sunny_talwar · Accepted solution]

May be just do this

Left Join (table)

LOAD ID,

     Max(Step) as MaxStep

Resident table

Group By ID;