Icon

06_​Basic_​Examples_​for_​Using_​the_​GroupBy_​Node

Basic Examples for using the GroupBy Node

This workflow shows the many aggregation options that the GroupBy node offers.
We start from customer data, group on Gender or more features, and run a few different aggregation methods on a few different features.

Basic Aggregations Group on one feature (Gender) Aggregations - count - percent Note These aggregations are feature independent. Basic Aggregations Group on one feature (Gender) Aggregations - unique count - missing value count - mode Note For numerical features as well as nominal Basic Aggregations Group on one feature (Gender) Aggregations - concatenate - unique concatenate - unique concatenate with count Note Also for numerical features, but output is String Statistical Aggregations Group on one feature (Gender) Aggregations - mean - sum - Std. deviation - Kurtosis - Min/Max vs First/Last Special Data Type (e.g Date) Aggregations Group on one feature (Gender) Aggregations - Date range - Mean Date - Minimum & Maximum Note - Special operations for most data types This workflow shows the many aggregation options offered by the GroupBy node.For more information see the workflow metadata. Find it here: View -> Description Customer Datacount, percentmean, sum, std dev.,Kurtosis- Concatenate- Unique concatenate- Unique concatenatew/ countMin/MaxvsFirst/LastDatesunique count,missing val count,mode Table Reader GroupBy GroupBy GroupBy GroupBy GroupBy GroupBy Basic Aggregations Group on one feature (Gender) Aggregations - count - percent Note These aggregations are feature independent. Basic Aggregations Group on one feature (Gender) Aggregations - unique count - missing value count - mode Note For numerical features as well as nominal Basic Aggregations Group on one feature (Gender) Aggregations - concatenate - unique concatenate - unique concatenate with count Note Also for numerical features, but output is String Statistical Aggregations Group on one feature (Gender) Aggregations - mean - sum - Std. deviation - Kurtosis - Min/Max vs First/Last Special Data Type (e.g Date) Aggregations Group on one feature (Gender) Aggregations - Date range - Mean Date - Minimum & Maximum Note - Special operations for most data types This workflow shows the many aggregation options offered by the GroupBy node.For more information see the workflow metadata. Find it here: View -> Description Customer Datacount, percentmean, sum, std dev.,Kurtosis- Concatenate- Unique concatenate- Unique concatenatew/ countMin/MaxvsFirst/LastDatesunique count,missing val count,mode Table Reader GroupBy GroupBy GroupBy GroupBy GroupBy GroupBy

Nodes

Extensions

  • No modules found

Links

Download

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

Download Workflow
Created by: Ferry
Created at: 2016-04-19
On NodePit since: 2025-02-18
Last update: 2026-07-17
Created with KNIME version: v4.1.1
Tags: ETLgroupbyaggregation

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

Try NodePit Runner!