Output - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product: Aster Analytics
Release Number: 6.21
Published: November 2016
Language: English (United States)
Last Update: 2018-04-14
dita:mapPath: kiu1466024880662.ditamap
dita:ditavalPath: AA-notempfilter_pdf_output.ditaval
dita:id: B700-1021
lifecycle: previous
Product Category: Software

Unpivot Output Table Schema
Column Name	Data Type	Description
accumulate_column	Same as in input table	Column copied from the input table.
attribute_column	VARCHAR	Unpivoted attribute.
value_column	VARCHAR	Appears when InputTypes('false'). Contains the unpivoted value of the corresponding attribute. Numeric values are cast to VARCHAR.
value_column_double	DOUBLE PRECISION	Appears when InputTypes('true') and an unpivot column has a real data type. Contains the unpivoted value of the corresponding attribute if the value is real; NULL otherwise.
value_column_long	LONG	Appears when InputTypes('true') and an unpivot column has an integer data type. Contains the unpivoted value of the corresponding attribute if the value is integer; NULL otherwise.
value_column_str	VARCHAR	Appears when InputTypes('true') and an unpivot column has a data type other than real or integer. Contains the unpivoted value of the corresponding attribute.