Limit the number of Rows of a particular attribute of a column

[ROHINK]

I have a table with 500 rows and one column has 3 attributes say “L”, “M” and “S”. I want only the top 20 rows of category “L” and top 15 rows of category “M” and top 40 rows of category “S”.
So how can I count the number and filter out only these specific number of rows in each category into a new output table

[mlauber71]

@ROHINK welcome to the KNIME forum

You could combine a group loop node with a rank or top-k node.

Selecting the top 50 rows of a table by a control column

Hi @sys4381 and welcome to KNIME Community, You can use the Row Sampling node to pick equal number of rows from a class (Randomly). Just select the “Stratified sampling” option the configuration window of the node and select the class column. You can choose how many rows you want in the output (absolute or relative). But if you insist to keep the first 50 rows in each class then I think you have to use the Group Loop Start node (include the class column) and the Row Filter node (Include row by…