1.1 - 8.10 - Pivoting Syntax Elements - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
October 2019
Content Type
Programming Reference
Publication ID
English (United States)
Specify 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.] Specify 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').

[Required if you specify PivotColumn.] Specify the values in pivot_column to use as pivot keys. The function ignores rows that contain other values in pivot_column.
[Optional] Use this syntax element only with the PivotColumn syntax element. If pivot_column is numeric, NumericPivotKey ('true') improves function performance slightly.
Default: 'false'
[Optional] Specify the names of the target columns (input columns that contain the values to pivot).