17.10 - Example: Using an IN List with Multiple Column Lists and Unspecified Aliases - 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)

In this example, the aliases that the IN list uses were not specified. Instead, the values of the yr_qtr column were built by adding the column names with an underscore symbol.

FROM star1p UNPIVOT ((sales, cogs)  FOR  yr_qtr IN
((Q101Sales, Q101Cogs),(Q201Sales, Q201Cogs), (Q301Sales, Q301Cogs)) Tmp;

country    state        yr_qtr                        sales         cogs
-------  -------- -----------------------            --------     --------
Canada     ON        Q201Sales_Q201Cogs                 10            0
Canada     ON        Q301Sales_Q301Cogs                 10            0
USA        NY        Q101Sales_Q101Cogs                 45           25
USA        CA        Q101Sales_Q101Cogs                 30           15
USA        CA        Q201Sales_Q201Cogs                 50           20