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.