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).
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 Snowflake Aggregate Functions.
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.