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

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

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;