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 Hub or Group Loop Start – KNIME Hub to do something with the blocks (export them delete lines with missing…