Loop on rows

KNIME Analytics Platform
1

Hello,

I am currently working on test data analysis. I need to generate some combinations if that is possible.

The inputs that I have:

A:

1
10
11
100
101
110
111
1000
1001

1010

B:

2
20
22
200
202

C:

3
30
33

What I wish to have: all the possible combinations of the three inputs in order: (A, B, C)

e.g. (1, 2, 3); (1, 2, 30); (10, 22, 33), etc.

one can easily notice there are many (10x5x3).

1. Is there  any node that can do this easily?

Otherwise, I managed to do it, but with a very tiresome method.

2. So is there any means of doing the following thing:

From A, to have:

2

2

2

20

20

20

22

22

22

200

200

200

202

202

202

A loop would be desirable. But I'm not sure how to use the loop nodes, or the Tablerow to Variable nodes and so on.

Even some quick tip would be appreciated.

Thanks!wink

Heej.

2

I guess you want to have Cartesian product between all different column, A, B and C. Let's assume you have only those 3 columns then you could use two Joiner nodes to perform the product operation based on a fake column containing the same values in all rows; this is used to do the join. This column can be appended by using either the Java Snippet or Rule Engine node. Those have to be applied on all columns individually together with the Missing Value node to remove rows with missing '?' values. Does this make sense? However, if you have dynamic number of columns, you might want to have a look into the variable and loop feature of KNIME. I think this answers also this thread: http://tech.knime.org/forum/knime-users/aerospace-test-data

3

There is also more detail on Cartesian joins at an older post too with more info.

http://tech.knime.org/node/20912

4

Thank you very much indeed!

It works perfect, even with multiple tables.

 

Heej.

5