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

This example specifies the target columns by name and specifies the default values for the optional arguments. If you omit the optional arguments, the result is the same.

Input

The input table, unpivot_input, contains temperature, pressure, and dewpoint data for three cities, in dense (pivoted) format.

SQL Call

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

Output

Because InputTypes has the value 'false', the value column has the data type VARCHAR.