this might have been answered before but I had a hard time finding the solution.
I have a table with exactly one row, with one value:
Name1
Forest
I have another table which looks like this:
Val1
Val2
Val3
Val4
A
1
1
A
B
2
2
C
C
3
3
E
D
4
5
I now want to create all possible combinations between both tables without any combination occuring twice.
Example result:
NameVals
ForestA11A
ForestB11A
ForestC11A
Etc.
The Cross Joiner Node didn’t help as it’s multiple columns. I tried to start it with loops but didn’t get far.
There might be statistical nodes that I might be able to use but I’m not familiar with them.
(Column headers shall be disregarded.)
Thanks @izaychik63 for your response. I probably didn’t express myself in enough detail or I’m not achieving the desired output with the mentioned nodes.
Apart from that I got it to work with just using column filters and cross joiners.
Each column is filtered from the rest and cross joined again starting from first to second column, result of first cross join to third column, result of second cross join to fourth column, etc.
In my case I remove rows with missing values and cross join the second table to have all data ready for further manipulation.
