Simple Loop

I am very new to KNIME and try to create simple loop. I have a table with 2 columns (i.e. Name and Number) as below
Name Number
A 1
B 2
C 3

What I try to achieve is to create new columns as below
Name Number
A 1
A 2
A 3
B 1
B 2
B 3
C 1
C 2
C 3

Do you have any suggestion or link to show how can I do it?

Thanks a lot

You can do this with the “Cross Joiner” node. (which requires two input tables, one for the first, one for the second column in your example – if you have only one table, use two “Column Filter” nodes to split the input columns).


You could use the Column Splitter node, which does this in one go :slight_smile:

1 Like

Thanks a lot. This is exactly what I wanted.

Thanks for your help.

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