7.00.02 - Example 1: Use Default Pivot Keys - 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)

This example specifies the PivotColumn argument. Because it does not specify the PivotKeys argument, the function uses every unique value in the PivotColumn as a PivotKey. The function pivots on the attribute column and outputs the contents of the t arget column, value, in dense format.