Icon

GroupBy

The GroupBy node is unique. No other node has the ability to group, summarize, and aggregate a table like it. With the GroupBy node, you can perform dozens of aggregations, including sum, mean, product, standard deviation, minimum, maximum, concatenate, create sets and collections, and more. You can choose to create groups according to the values in one or more columns, or create no groups at all.


The GroupBy node's configuration menu has several tabs which you should be familiar:

Groups
As its name suggests, this tab is where you select which fields, if any, you wish to group together. When you include fields in this tab, the output table will have one row per unique combination of values from the selected columns.

Aggregations
There are three aggregation tabs. Very similar to the Column Filter, these tabs allow you to create aggregations manually, by wildcard or regular expression, or according to column types.

The aggregation methods available are controlled by the fields you wish to aggregate. Numeric fields will have options such as sum, mean, standard deviation, and variance. String fields will have options for concatenate, first, last, and mode. Many aggregation types are available for both numeric and string fields.

GroupBy The GroupBy node is unique. No other node has the ability to group, summarize, andaggregate a table like it. With the GroupBy node, you can perform dozens ofaggregations, including sum, mean, product, standard deviation, minimum, maximum,concatenate, create sets and collections, and more. You can choose to create groupsaccording to the values in one or more columns, or create no groups at all.The GroupBy node's configuration menu has several tabs which you should befamiliar:GroupsAs its name suggests, this tab is where you select which fields, if any, you wish togroup together. When you include fields in this tab, the output table will have one rowper unique combination of values from the selected columns.AggregationsThere are three aggregation tabs. Very similar to the Column Filter, these tabs allowyou to create aggregations manually, by wildcard or regular expression, or according tocolumn types.The aggregation methods available are controlled by the fields you wish to aggregate.Numeric fields will have options such as sum, mean, standard deviation, and variance.String fields will have options for concatenate, first, last, and mode. Many aggregationtypes are available for both numeric and string fields. Grouping by Country and summing Population yieldsa table with two records and two columns:One record per unique value in Country and thesummed Population column. Grouping by Country and Region gives a table withone row per unique combination of these columns'values. Aggregating Population by sum and meangives two aggregation columns at the County-Regionlevel of detail. You can create lists and sets with the GroupBy node.Here, we have created lists of states, codes, andcapitals. Sets are often helpful when using flow variables tocontrol a node's configuration settings. The GroupBy node is also useful for creating a tableof unique values, often used for lookup tables. Here,we have only grouped by the State field -- noaggregation. Night Heron Data, 2023 Input some dataGroup byone field, aggregateGroup by multiplefieldsGroup, createlistsGroup, noaggregation Table Creator GroupBy GroupBy GroupBy GroupBy GroupBy The GroupBy node is unique. No other node has the ability to group, summarize, andaggregate a table like it. With the GroupBy node, you can perform dozens ofaggregations, including sum, mean, product, standard deviation, minimum, maximum,concatenate, create sets and collections, and more. You can choose to create groupsaccording to the values in one or more columns, or create no groups at all.The GroupBy node's configuration menu has several tabs which you should befamiliar:GroupsAs its name suggests, this tab is where you select which fields, if any, you wish togroup together. When you include fields in this tab, the output table will have one rowper unique combination of values from the selected columns.AggregationsThere are three aggregation tabs. Very similar to the Column Filter, these tabs allowyou to create aggregations manually, by wildcard or regular expression, or according tocolumn types.The aggregation methods available are controlled by the fields you wish to aggregate.Numeric fields will have options such as sum, mean, standard deviation, and variance.String fields will have options for concatenate, first, last, and mode. Many aggregationtypes are available for both numeric and string fields. Grouping by Country and summing Population yieldsa table with two records and two columns:One record per unique value in Country and thesummed Population column. Grouping by Country and Region gives a table withone row per unique combination of these columns'values. Aggregating Population by sum and meangives two aggregation columns at the County-Regionlevel of detail. You can create lists and sets with the GroupBy node.Here, we have created lists of states, codes, andcapitals. Sets are often helpful when using flow variables tocontrol a node's configuration settings. The GroupBy node is also useful for creating a tableof unique values, often used for lookup tables. Here,we have only grouped by the State field -- noaggregation. Night Heron Data, 2023 Input some dataGroup byone field, aggregateGroup by multiplefieldsGroup, createlistsGroup, noaggregation Table Creator 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: johnemery
Created at: 2023-05-19
On NodePit since: 2023-05-21
Last update: 2024-05-02
Created with KNIME version: v4.7.2
Tags: groupbynode bitesnight heron data

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

Try NodePit Runner!