Exlude values

[#1]

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

[alexandros17]

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;