7.00.02 - Output - 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)
Pivot Output Table Schema with NumberOfRows Argument
Column Name Data Type Description
partition_column Any Any number of columns from the input table, specified in the PartitionColumns argument.
value_i Any The output table has number_of_rows columns, each containing a value from a target column. These columns appear in the order specified by the ORDER BY clause. Their names are value_0, value_1, and so on.
Pivot Output Table Schema with PivotColumn Argument
Column Name Data Type Description
partition_column Any Any number of columns from the input table, specified in the PartitionColumns argument.
value_metric_column Any The output table has one column for each pivot_key. The column contains the values for that pivot_key that are associated with the partitions in that row.