1.0 - 8.00 - Unpivoting Example 3: Specified Target Range, Default Optional Values - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

This example specifies a range of target columns and uses the default values for the optional arguments.

SQL Call

This call is equivalent to the call in Example 1Unpivoting Example 1: Specified Target Columns, Default Optional Values.

SELECT * FROM Unpivoting (
  ON unpivot_input
  USING
  TargetColumns ('[3:5]')
  Accumulate ('sn', 'city', 'week')
  InputTypes ('false')
) AS dt ORDER BY 1, 2, 3;