Unpivot

The Unpivot component rotates a table by transforming columns into rows.

This operator can be used to transform a wide table (e.g. jan_sales, feb_sales, mar_sales) into a narrower table (e.g. month, sales).

Snowflake: UNPIVOT is a relational Snowflake operator that accepts two columns (from a table), along with a list of columns, and generates a row for each column specified in the list. In a query, it is specified in the FROM clause after the table name.

Synapse: For more information, see the Microsoft documentation.

Delta Lake: This component is only available for Matillion ETL for Delta Lake on Databricks instances on AWS (not Azure).

Note

The Unpivot component is not a direct reverse of the Pivot component, since UNPIVOT cannot undo aggregations made by PIVOT.

---

SnowflakeDelta Lake on DatabricksAzure Synapse Analytics

Name = string

A human-readable name for the component.

---

Columns to Narrow = dual listbox

Select the columns in the source table to narrow into a single pivot column. The column names will populate name_column, and the column values will populate value_column.

---

Output Names Column Name = string

Assign a name to the generated column that will be populated with the names from the columns in the column list.

---

Output Values Column Name = string

Assign a name to the generated column that will be populated with the values from the columns in the column list.

Name = string

A human-readable name for the component.

---

Columns to Narrow = dual listbox

Select the columns in the source table to narrow into a single pivot column. The column names will populate name_column, and the column values will populate value_column.

---

Output Names Column Name = string

Assign a name to the generated column that will be populated with the names from the columns in the column list.

---

Output Values Column Name = string

Assign a name to the generated column that will be populated with the values from the columns in the column list.

Name = string

A human-readable name for the component.

---

Grouping Columns = dual listbox

Select the columns to pass through.

---

Unpivot Key Name = string

Specify the name of the unpivot column.

---

Unpivot Value Column = string

Specify the name of the unpivot value column.

---

Unpivot Source List = dual listbox

Select which source columns are to be un-pivoted.

---

Video

---

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