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 |
---|---|---|---|---|
✅ | ✅ | ❌ | ❌ | ✅ |