Challenging (?) Task - Grouping Marked Rows

[mlauber71]

@badger101 you could adapt this workflow and use the blocks to fill in the desired markers with a Counter creator and the use the Group By node to create the “Group Members”. Maybe you upload a file that would represent your complete task

Move head rows to a column

@willy_oracle typically you would mark all lines with a Counter. Then identify the ‘headers’ with a rule engine [IF Col1 LIKE “Head*” => Counter] and keep that (starting) row in a separate column. Then you fill the missings with the previous value so a block would emerge marking the data table: [image] So now you have the blocks marked an can use a Table Row to Variable Loop Start – KNIME Community Hub or Group Loop Start – KNIME Community Hub to do something with the blocks (export them delet…