Groupby and sort

[Brain]

Hi
This is a small example of my data.
I want to group by name and date and keep only the top 3 most recent date by name.
The last part is my problem
SAMPLE.xlsx (9.0 KB)
Thanks
Br

[MartinDDDD]

you can:

1. use group by to remove duplicates
2. send data to group loop
3. inside the loop use top k row filter to only keep last threee (or first three) dates per name

Prototype:

groupbbyandsort.knwf (92.7 KB)

Overview:

[Brain]

Thanks
My problem was the loop