Arguments - 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
Argument Category Description
Unpivot Optional Specifies the names of the unpivot columns—the input columns to unpivot (convert to rows).
If you do not specify this argument, you must specify the UnpivotRange argument.
UnpivotRange Optional Specifies ranges of unpivot columns. You must type the brackets in this context—they are range delimiters, not indicators that the syntax element is optional. The start_column and end_column are nonnegative integers that represent the positions of columns in the input table.The first column is in position 0. No start_index can be greater than its corresponding end_index. The range includes its endpoints.
If you do not specify this argument, you must specify the Unpivot argument.
Accumulate Required 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 whether the unpivoted value column, in the output table, has the same data type as its corresponding unpivot column (if possible). The default value is 'false'—for each unpivoted column, the function outputs the values in a single VARCHAR column.

If you specify 'true', the function outputs each unpivoted value column in a separate column. If the unpivot column has a real data type, the unpivoted value column has the data type DOUBLE PRECISION; if the unpivot column has an integer data type, the unpivoted value column has the data type LONG; if the unpivot column has any other data type, the unpivoted value column has the data type VARCHAR.

AttributeColumn Optional Specifies the name of the unpivoted attribute column in the output table. The default value is 'attribute'.
ValueColumn Optional Specifies the name of the unpivoted value column in the output table. The default value is 'value'.