1.1 - 8.10 - Unpivoting Syntax Elements - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Published
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)
TargetColumns
Specify the names of the target columns—the input columns to unpivot (convert to rows).
Accumulate
Specify the names of input columns—other than target columns—to copy to the output table. You must specify these columns in the same order that they appear in the input table. No accumulate_column can be a target_column.
InputTypes
[Optional] Specify the data types of the unpivoted values in the output table.
If you specify 'true', instead of one column for all attribute values, the output table includes three columns (_long, _double, and _str). The unpivoted value appears in the column corresponding to the value’s data type in the input table.
Default: 'false' (For each unpivoted column, the function outputs the values in a single VARCHAR column.)
AttributeColumn
[Optional] Specify the name of the unpivoted attribute column in the output table.
Default: 'attribute'
ValueColumn
Specify the name of the unpivoted value column in the output table.
Default: 'value_col'