Row Filter Groupby ??

[Brain]

Hi

I want to select:
The 5 most recent rows for each Name, ordered by Date. Then delete the highest and lowest value column SP.

I’m looking for an efficient method because there are many names, and they will change frequently.

Exemple :

GRACIOUS EXPRESS : keep only rows by date => 2025/07/09 - 2025/05/28 - 2025/04/06 - 2025/03/09 and 2025/09/02. Then delete lowest value SP = row 2025/09/02 and highest value SP row 2025/05/28

And i want to do the same thing for each different name.

Any idea ?

Thanks

Br

PAST PERF 1.xlsx (8.8 KB)

[gonhaddock]

Hello @Brain
You can give a try to ‘Top k Row Filter’ node:

Top k Row Filter

Regards

[Brain]

Hi @gonhaddock

My problem is to deal also with the name. It’sTop5 by Name and by date.

[mlauber71]

@Brain maybe like this. First select Top 5 per Date in each Group:

Then only keep the 3 Rows in the middle:

Top K Selection by Groups - KNIME Forum (90132) – mlauber71

[rfeigel]

In your example, isn’t 2025/03/09 the “highest”?

[mlauber71]

@rfeigel indeed if you sort just by the highest and lowest date after one has selected the TOP 5 then it is like this: