Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts
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!
Jan
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;