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

Because InputTypes has the value 'true', the output table has a separate value column for each unpivot column. The unpivot columns temp, pressure, and dewpoint have the data types INTEGER, DOUBLE PRECISION, and VARCHAR (respectively); therefore, their corresponding unpivoted columns have the data types LONG, DOUBLE PRECISION, and VARCHAR.

Unpivot Example 2 Output Table
sn city week climate_attributes attributevalue_long attributevalue_double attributevalue_str
1 Asheville 1 temp 32    
1 Asheville 1 pressure   1020.79998779297  
1 Asheville 1 dewpoint     27.6F
2 Asheville 2 temp 32    
2 Asheville 2 pressure   1021.29998779297  
2 Asheville 2 dewpoint     27.4F
3 Asheville 3 temp 34    
3 Asheville 3 pressure   1021.70001220703  
3 Asheville 3 dewpoint     28.2F
4 Nashville 1 temp 42    
4 Nashville 1 pressure   1021  
4 Nashville 1 dewpoint     29.4F
5 Nashville 2 temp 44    
5 Nashville 2 pressure   1019.79998779297  
5 Nashville 2 dewpoint     29.2F
6 Brownsville 2 temp 47    
6 Brownsville 2 pressure   1019  
6 Brownsville 2 dewpoint     28.9F
7 Brownsville 3 temp 46    
7 Brownsville 3 pressure   1019.20001220703  
7 Brownsville 3 dewpoint     28.9F