Hello
I have a table that I would like to iterate over the columns where each time I would like to add the current column to the previous columns and perform groupBy.
Hi Malik
I think that looping group by is not a feasible approach… you rather do for every column of your choice a separat group by. And joining group by results is not making much sense as you will have different aggregations…
Maybe pivots can help…
Maybe concatenations make more sense than joins…
If you give us a bit more details of your task we might find a wf…
Hi
Thanks for your reply. I have as input a table that consists of n columns. I would loop over the columns in such way that the first time i consider the first column, the next iteration I would consider the first two columns, then on the next iteration, I would consider the first 3 columns and so on. In each iteration, I would like to perform GroupBy on the generated table.
Malik
I think i solved one part of the problem. How now i can tell GroupBy to use the rows in the table as group?
The only chance is to use variables…I’m unfortunately too busy to help out right now but have a look at the example server for variable wf
These are the red dot connectors on the top of the nodes…
