Icon

GroupBy_​FlowVariables_​mp

Using Flow Variables with GroupBy

In order to use the GroupBy node dynamically, you will need to convert your group columns, aggregate columns, and methods of aggregation into list variables. This workflow shows a simple example of how to do this.

Methods of AggregationGroupsAggregate ColumnsConverting to List of GroupsConverting to List of AggregatesConverting to List of Aggregates"Groups""Aggregates""Methods"Node 20Node 21Node 22Node 23" Types" Table Creator ExtractColumn Header Transpose Row Filter Row Filter GroupBy GroupBy GroupBy Table Rowto Variable Column Rename Column Rename Column Rename Table Rowto Variable Table Rowto Variable Merge Variables Table Creator GroupBy Extract Table Spec ReferenceRow Filter GroupBy Column Rename Table Rowto Variable Methods of AggregationGroupsAggregate ColumnsConverting to List of GroupsConverting to List of AggregatesConverting to List of Aggregates"Groups""Aggregates""Methods"Node 20Node 21Node 22Node 23" Types" Table Creator ExtractColumn Header Transpose Row Filter Row Filter GroupBy GroupBy GroupBy Table Rowto Variable Column Rename Column Rename Column Rename Table Rowto Variable Table Rowto Variable Merge Variables Table Creator GroupBy Extract Table Spec ReferenceRow Filter GroupBy Column Rename Table Rowto Variable

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: stephen.rauner
Created at: 2021-08-04
On NodePit since: 2022-03-27
Last update: 2024-04-27
Created with KNIME version: v4.5.1
Tags: GroupByDynamic

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!