Groupby and sort

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

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:

4 Likes

Thanks
My problem was the loop

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.