Unpivoting Example 2: Specified Target Columns, Specified Optional Values - Teradata Vantage

This example specifies the target columns by name and specifies nondefault values for the optional arguments.

Input

• Input table: unpivot_input, as in Unpivoting Example 1: Specified Target Columns, Default Optional Values

SQL Call

SELECT * FROM Unpivoting (
  ON unpivot_input
  USING
  TargetColumns ('temp', 'pressure', 'dewpoint')
  AttributeColumn ('climate_attributes')
  ValueColumn ('attributevalue')
  InputTypes ('true')
  Accumulate ('sn', 'city', 'week')
) AS dt ORDER BY 1,2,3;

Output

Because InputTypes has the value 'true', the output table has a separate value column for each target column. The target columns temp, pressure, and dewpoint have the data types INTEGER, DOUBLE PRECISION, and VARCHAR (respectively); therefore, their corresponding unpivoted columns have the data types LONG, DOUBLE PRECISION, and VARCHAR.