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 sub-query.

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, read the following:


Pivot Column = drop-down

Specify the column from the source table or sub-query 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 sub-query 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 = multiple strings

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


Snowflake Databricks Amazon Redshift (preview)