I would like to know if someone can help me. I have the following table that has columns with hierarchy as shown here [image] I would like to be able to have a new column or the same Name column with the names down depending on the one at the top. If I get to what it says total, then a new name should appear. [image] I tried to do some kind of rule based iteration, but I didn’t have good results. The data always changes, so it is untenable to have a rule according to the row ID. Best

@DanielaQ you can take a look at this example [image] Move head rows to a column KNIME Analytics Platform @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…

Help with hierarchy in a table

KNIME Analytics Platform

mlauber71 March 1, 2023, 5:58pm 3

@DanielaQ you can take a look at this example

1 Like