For several groups I can run several joiners but what if the group number goes to 100 or 1000.
I think I can leverage Loop to run multiple iterations. But I am not clear what do you.
Would it possible to share the workflow for this and I can apply to 100 times?
instead of using a loop, I would use the unpivoting node and only one joiner (and an additional row filter ) .
Unpivoting node:
The unpivoting node rotates selected columns from the input table to rows and duplicates at the same time the remaining input columns by appending them to each corresponding output row.
In your example the columns you want to rotate (called value columns) are the groups (Genka 1, Genka 2,ā¦) and the retaining column is the column item.
Row Filter node:
As a result you will end up with a lot of missing values or empty cells in the value column. You can remove them with a Row Filter node.
Joiner node:
Next you can use the Joiner node and join based on your Groups.
I hope this helps you building your workflow. If not please let me know and Iām happy to explain it in more detail.