7.00.02 - Unpivot Arguments - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Unpivot
Specifies the names of the unpivot columns—the input columns to unpivot (convert to rows).
Accumulate
Specifies the names of input columns—other than unpivot 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 an unpivot column.
InputTypes
[Optional] Specifies the data types of the unpivoted values in the output table. Default: 'false' (for each unpivoted column, the function outputs the values in a single VARCHAR column).

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.

AttributeColumn
[Optional] Specifies the name of the unpivoted attribute column in the output table. Default: 'attribute'.
ValueColumn
Specifies the name of the unpivoted value column in the output table. Default: 'value'.