variable to control column to groupby in groupby node

[knimeavnst]

I want to make a component using groupby node. I want the column to group by controlled by configure variable. But looks the groupby node does not allow column to group by controlled by flow variable. Is there any solution for that?

[elsamuel]

But looks the groupby node does not allow column to group by controlled by flow variable. Is there any solution for that?

This is already a feature.

In the screenshot I have defined a string variable called GroupByColumn which contains the name of the column I want to group by, and I’ve instructed the GroupBy node to use it for this purpose.

[ipazin]

Hello @knimeavnst,

in case you are grouping by multiple columns (which I assume you plan to offer in your Component) you’ll need to control IncList with list/collection flow variable type and not string. Check this topic for more info:

How to apply different column combinations (>1 column) in GROUP BY node by flow variables

Dear all, Via this forum I found out how I can make use of a Flow Variable in combination with the GROUP BY node. The example workflow that I found allows me to ‘group by’ my dataset on only one ‘variable’ column. [image] I would like to be able to ‘group by’ on a combination of more than one column that are being set by Flow Variables. Example of column combinations that I would like to group on: [image] By using a ‘Loop’ I would like the group by node to perform 6 times a grouping base…

It features workflow example that you can use. Note that with newer versions Table Row to Variable Loop Start node does support (new) flow variables types and you can use it.

Br,
Ivan