7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
zuk1466006200888

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