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)

@Brain maybe like this. First select Top 5 per Date in each Group: [image] Then only keep the 3 Rows in the middle: [image] [image] Top K Selection by Groups - KNIME Forum (90132) – mlauber71 Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

Row Filter Groupby ??

KNIME Analytics Platform

mlauber71 October 6, 2025, 12:52pm 4

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

Then only keep the 3 Rows in the middle:

3 Likes