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

Sounds like a job for the Missing Value Node: [image] Missing Value This node helps handle missing values found in cells of the input table. The first tab in the dialog (labeled "Default") provides default handling options for … Set it in such a way that the missing values take the new values from the previous row.

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