Simple Loop

[kengdeb]

Hi
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

[qqilihq]

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).

Best,
Philipp

[gab1one]

You could use the Column Splitter node, which does this in one go https://nodepit.com/node/org.knime.base.node.preproc.split2.SplitNodeFactory2

[kengdeb]

Thanks a lot. This is exactly what I wanted.

[kengdeb]

Thanks for your help.