Skip to content

Pivot

The Pivot component rotates, or pivots a table by turning the individual values from one column in the input expression into several columns, and aggregates results (where needed) on any remaining column values. In a query, it is specified in the FROM clause following the table name or subquery.

This component supports built-in aggregate functions.

The component can be used to transform a narrow table (e.g. sales, month) into a wider table (e.g. jan_sales, feb_sales).


Properties

Name = string

A human-readable name for the component.


Aggregate Function = drop-down

Select which aggregate function to call to combine the grouped values from the Pivot Column. For more information, see:


Pivot Column = drop-down

Specify the column from the source table or subquery that will be aggregated. This requires an input component before configuring. It uses the column names from the input component.


Value Column = drop-down

Specify the column from the source table or subquery that contains the values from which column names will be generated. This requires an input component before configuring. It uses the column names from the input component.


Pivot Values = dual listbox

A list of values for the pivot column to pivot into headings in the query results.


Video


Snowflake Delta Lake on Databricks Amazon Redshift Google BigQuery Azure Synapse Analytics