TD_Unpivoting Output - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-01
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantage™

Output Table Schema

Column Data Type Description
id_column Any Column copied to output table.
AttributeName VARCHAR or SMALLINT Column which contains the unpivoted attribute or attribute alias or index of the target column.
AttributeValue Original compatible data type from InputTable if all columns are of same group or VARCHAR Column which contains the unpivoted values of the attribute. (Column appears if InputTypes is ‘false’).
AttributeValue_<GRP_NAME> According to the group Column which contains the unpivoted values of the attribute, for example, AttributeValue_Num.(Columns appears if InputTypes is ‘true’). Supported GRP_NAME are: {Num, Char, Clob, Byte, Blob, Date, Time, TimeWithTZ, TimeStamp, TimeStampWithTZ, IntervalSecond, IntervalMinute, IntervalHour, IntervalDay, IntervalMonth, IntervalYear, IntervalMinuteSecond, IntervalHourSecond, IntervalHourMinute, IntervalDaySecond, IntervalDayMinute, IntervalDayHour, IntervalYearMonth }
DataTypes VARCHAR Column which contains the original data type name from the InputTable.
accumulate_column Any Column copied to output table.