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:
- use group by to remove duplicates
- send data to group loop
- 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.