Filter on the maximum date inside a group

1

Hi,
I have a data set with several lines with different dates for the same personnel number (the positions held by the person during his career)
I want to keep only his last position, that is to say, filter on the max date for each personnel number.
I thought of :- making a derived table, then an aggregation on the max date per matricule, then a join with the original table.
Is there a more direct method?
I really appreciate any help you can provide.

2

Hi Michel,

The “Keep min/max” action should do the trick. It supports grouping, so you can define groups with the personnel number.

image

3

Many thanks Dmitry,
Brilliant as always.
I am amazed at what can be done so elegantly and powerfully with EasyMorph

1 Like