Unpivoting Syntax Elements - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantage™
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'