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!):

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, if you didnt do the previous step then there will be no ‘0’ option here):

image

If you got this right, then at the bottom of the main ‘Settings’ tab, you should now see:

You are now ready to try it.

The very simple example show here is attached.

Groupby with flow var.knwf (13.2 KB)

Steve

3 Likes