UNPIVOT Function | Teradata Vantage - 17.10 - UNPIVOT - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

UNPIVOT is the reverse of the PIVOT operation. It provides a mechanism for transforming columns into rows.

The UNPIVOT functionality was introduced previously via the TD_UNPIVOT table operator. This feature introduces grammar to support the UNPIVOT operator in the FROM clause of the SELECT statement.

UNPIVOT invokes the TD_UNPIVOT table operator internally. You can still use TD_UNPIVOT independent of UNPIVOT.