Group nodes

Group nodes group a table by one or more columns and aggregate over other columns. They take one input node. Create a group node by selecting an existing node and clicking New group node on the new node toolbar floating to the right.

Configuration

The base query is configured by:

• Group by - A list of columns by which to group the table.
• Aggregate - A list of aggregations, each of which will add another column. By default, there is one “Row count” aggregation. The possible aggregations are:
  • Row count
  • Count not null of column
  • Mode of column
  • Min of column
  • Max of column
  • Sum of column
  • Mean of column

That base query can be refined by the standard controls shared by all table nodes.

SQL equivalent

If you clicked “Copy SQL” in the node menu of the node pictured above, you’d get:

WITH
  "p" AS (…),
  "p1" AS (SELECT
      "p"."CATEGORY",
      AVG("PRICE_PER_UNIT") AS "MEAN_PRICE_PER_UNIT",
      MIN("PRICE_PER_UNIT") AS "MIN_PRICE_PER_UNIT",
      MAX("PRICE_PER_UNIT") AS "MAX_PRICE_PER_UNIT"
    FROM "p"
    GROUP BY "p"."CATEGORY")
SELECT
  "CATEGORY",
  "MEAN_PRICE_PER_UNIT",
  "MIN_PRICE_PER_UNIT",
  "MAX_PRICE_PER_UNIT"
FROM "p1"

In the real version, … would show the SQL code for the input node.