Icon

07_​Advanced_​Usage_​of_​the_​GroupBy_​node

GroupBy Advanced Examples

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. Here we demonstrate grouping on multiple features, pattern based grouping and aggregation without grouping for calculating statistics.

Multiple Grouping Features Group on multiple (2+) features Aggregations - count - percent - unique count Pattern/Type based Aggregation Group on one (or multiple) features Aggregations - on pattern based features - on type based features Just Aggregation, no Grouping As a result the aggregation is calculated on the whole input data table. Just Grouping, no Aggregation Result is the List of values or of value combinations This workflow shows advanced examples of the aggregation options offered by the GroupBy node.For more information see the workflow metadata. Find it here: View -> Description Customer Datacount, percent,unique countPattern basedType basedNo groupingfeatureNo aggregationmethod Table Reader GroupBy GroupBy GroupBy GroupBy GroupBy Multiple Grouping Features Group on multiple (2+) features Aggregations - count - percent - unique count Pattern/Type based Aggregation Group on one (or multiple) features Aggregations - on pattern based features - on type based features Just Aggregation, no Grouping As a result the aggregation is calculated on the whole input data table. Just Grouping, no Aggregation Result is the List of values or of value combinations This workflow shows advanced examples of the aggregation options offered by the GroupBy node.For more information see the workflow metadata. Find it here: View -> Description Customer Datacount, percent,unique countPattern basedType basedNo groupingfeatureNo aggregationmethod Table Reader GroupBy GroupBy GroupBy GroupBy GroupBy

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: Ferry
Created at: 2016-04-19
On NodePit since: 2019-07-12
Last update: 2024-04-18
Created with KNIME version: v4.1.1
Tags: ETLgroupbyaggregationgrouping

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

Try NodePit Runner!