Creating all combinations of two tables with multiple columns
Hey you guys,
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.)
Thank you!