Unpivot Syntax - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software
Version 1.2
SELECT * FROM Unpivot (
  ON input_timeseries_table
  [ Unpivot ({ 'unpivot_column' | 'unpivot_range' }[,…]) |
    UnpivotRange ('[start_index:end_index]' [,…])
  Accumulate ({ 'accumulate_column' | 'accumulate_column_range' }[,…])
  [ InputTypes ({'true'|'yes'|'t'|'y'|'1'|'false'|'no'|'f'|'n'|'0'}) ]
  [ AttributeColumn ('attribute_column') ]
  [ ValueColumn ('value_column') ]
);