UNPIVOT Function Examples | VantageCloud Lake - UNPIVOT Function Examples - Teradata Vantage

The examples in this section use the following denormalized pivoted table, star1p, which is defined as:

CREATE TABLE star1p(country VARCHAR(20),state VARCHAR(20),Q101Sales INTEGER,Q201Sales INTEGER,Q301Sales INTEGER,Q101Cogs INTEGER,Q201Cogs INTEGER,Q301Cogs INTEGER);

SELECT * FROM star1p;

The star1p table contains:

country  state  Q101Sales  Q201Sales  Q301Sales  Q101Cogs  Q201Cogs  Q301Cogs
-------  -----  ---------  ---------  ---------  --------  --------  --------
Canada    ON        ?         10          ?         ?         0         ?
Canada    BC        ?          ?         10         ?         ?         0
USA       NY       45          ?          ?        25         ?         ?
USA       CA       30         50          ?        15        20         ?

• Example: Unpivoted Sales and Cogs Columns
• Example: Using UNPIVOT for a Unique Year Value
• Example: Normalizing the UNPIVOT Operation
• Example: Using UNPIVOT with the INCLUDE NULLS Clause
• Example: Using UNPIVOT with the EXCLUDE NULLS Clause
• Example: Using an IN List with Multiple Column Lists and Unspecified Aliases
• Example: Using an IN List that Contains Multiple Columns with a Compatible Data Type
• Example: Using an IN List that Contains Multiple Columns with an Incompatible Data Type