"Group by" column names coming from external source

[alex_never]

I think I saw something similar before on the forum.

Please, take a look:

How to control GROUP BY NODE using flow variables

OK, here is a very simple example: [image] Firstly you must make sure the Table Row To Variable Loop Start node is executed before trying to configure the GroupBy node. In the GroupBy node settings window, add a column (any column at all - doesnt matter, as long as you have a column there!): [image] Now, switch to the ‘Flow Variables’ tab, and expand the ‘grouByColumns’ [sic!] and then ‘InclList’. in the ‘0’ box, select the variable you want which will contain the grouping column name (NB…

Using flow variables to set GroupBy grouping columns

Hi, you need to preconfigure the groupby node for being able to do this. only after the first configuration you can define the flow variables. You than can use pattern based aggregation page and add a predefined number of rows. Each row can than be controlled from the outside via flow variables. As it is a regex, you can also construct a regex which will match multiple columns at once. i hope this helps to get you started! Cheers, Iris 

I hope that help you.

BR,
Alex