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)

The function outputs the contents of the input column in dense format in the output columns value_temp and value_pressure, which contain the temperature and pressure, respectively. Because these values are numeric, the function casts them to VARCHAR.

Pivot Example 2 Output Table
sn city week value_pressure value_temp
1 Asheville 1 1020.8 32
2 Asheville 2 1021.3 32
3 Asheville 3 1021.7 34
4 Nashville 1 1021 42
5 Nashville 2 1019.8 44
6 Brownsville 2 1019 47
7 Brownsville 3 1019.2 46