7.00.02 - Pivot Arguments - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Aster Analytics
Release Number
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
English (United States)
[Optional] Specifies the schema of the input table. Default: PUBLIC.
Specifies the same columns as the PARTITION BY clause (in any order).
[Required if you omit PivotColumn.] Use NumberOfRows when no column contains pivot keys, but you can specify a maximum number of rows in any partition. The function pivots the input rows into this number of columns in the output table.

If a partition has fewer than number_of_rows rows, the function adds NULL values; if a partition has more than number_of_rows rows, the function omits the extra rows.

If you use NumberOfRows, you must use the ORDER BY clause to order the input data; otherwise, the contents of the output table columns may vary from run to run.

[Required if you omit NumberOfRows.] PivotColumn specifies the name of the input column that contains the pivot keys.

If pivot_column contains numeric values, the function casts them to VARCHAR; function performance improves slightly if you specify NumericPivotKey ('true').

[Optional] Use this argument only with the PivotColumn argument, to specify the values in pivot_column to use as pivot keys. The function ignores rows that contain other values in pivot_column.

Default behavior: The function uses every unique value in pivot_column as a pivot key.

[Optional] Use this argument only with the PivotColumn argument. If pivot_column is numeric, NumericPivotKey ('true') improves function performance slightly. Default: 'false'.
[Optional] Specifies the names of the target columns (input columns that contain the values to pivot).