GroupBy 0 ×
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.
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. Grouping by Country and summing Population yields a table with two records and two columns: One record per unique value in Country and the summed Population column. Grouping by Country and Region gives a table with one row per unique combination of these columns' values. Aggregating Population by sum and mean gives two aggregation columns at the County-Region level of detail. You can create lists and sets with the GroupBy node. Here, we have created lists of states, codes, and capitals. Sets are often helpful when using flow variables to control a node's configuration settings. The GroupBy node is also useful for creating a table of unique values, often used for lookup tables. Here, we have only grouped by the State field -- no aggregation. Night Heron Data, 2023 Input some data Group by one field, aggregate Group by multiple fields Group, create lists Group, no aggregation Table Creator GroupBy GroupBy GroupBy GroupBy 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. Grouping by Country and summing Population yields a table with two records and two columns: One record per unique value in Country and the summed Population column. Grouping by Country and Region gives a table with one row per unique combination of these columns' values. Aggregating Population by sum and mean gives two aggregation columns at the County-Region level of detail. You can create lists and sets with the GroupBy node. Here, we have created lists of states, codes, and capitals. Sets are often helpful when using flow variables to control a node's configuration settings. The GroupBy node is also useful for creating a table of unique values, often used for lookup tables. Here, we have only grouped by the State field -- no aggregation. Night Heron Data, 2023 Input some data Group by one field, aggregate Group by multiple fields Group, create lists Group, no aggregation Table Creator GroupBy GroupBy GroupBy GroupBy
