Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be just do this
Left Join (table)
LOAD ID,
Max(Step) as MaxStep
Resident table
Group By ID;
May be just do this
Left Join (table)
LOAD ID,
Max(Step) as MaxStep
Resident table
Group By ID;