I have the following problem:
I gave multiple entries for one person:
I would ONLY like to load the "azmnr" for this person that has the max "marazmnr".
How would I have to script this?
Thank you for your help!
this is the code you need:
AAA: LOAD * Inline [ marnr, fullname, azmnr, model, marazmnr 30, christian, 42, A, 53 30, christian, 42, A, 194 30, christian, 47, B, 167 ]; inner Join LOAD marnr, azmnr, max(marazmnr) as marazmnr Resident AAA Group By marnr, azmnr;
Retrieving data ...