How to generate all combinatorial possible text strings?

KNIME Analytics Platform
1

Hi there,

I have this rather simple thing, that I want to do, but since I’m rather new to KNIME, I hope someone can give be piece of advice: I have eg three sets of text strings X0001 - X0010, Y0001 - Y0010, and Z0001-Z0010 (10 in each set as input from individual .csv files or sheets in .xls) and I’d like to generate all possible combinations of “X00xx_Y00yy_Z00zz” concatenated text strings - in this simple case one thousand combinations.

I have a feeling that I need a set of loops to do this, but can’t seem to get it to work. Any input will be highly appreciated.

Best,
Kolster

2

Loops are not necessary in this case, you can achieve this with two Cross Joiner nodes.

Best,
Philipp

2 Likes
3

Hi Philipp,

Thank you for the quick reply - i works beautifully! I was not aware of the cross joiner node - I guess you learn every day.

Best,
Kolster

1 Like