variable loop, duplicating row ID

Dear All,
First I’m a very beginner in knime.

I’ve those data (super simplified, obviously)

image

and basically I want to create a new column based on an other table, that countains all variable.

I’ve variables like

image

and a varible loop, and then 3 rule engines like this

image

with control of new column name from variable

image

The expected result may look like an unpivot, but it won’t be the case in file project since rule engine may be a way more complicated (I’ve simplified for sharing).

my problem is:
the loop is creating new rows at each new loop instead of using the row in the starting table.

Can you have a look at it and tell me where is the error ? thank you.

image
Test_Loop.knwf (15.8 KB)

Hi @Zarkoff95 welcome to KNIME forum

I made a small modification to your workflow Test_Loop 2.knwf (40.9 KB).


I changed the loop end with a Column Append Loop End node, added a Column Filter node. And then Append the original table to your results. Is this where you are looking for?
gr. Hans

4 Likes

@HansS That’s perfect, thank you very much for your help.

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.