TD_Unpivoting Input - 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ā„¢

InputTable Schema

Column Name Data Type Description
id_column Any Column which contains the identifier values.
target_column CHAR, VARCHAR, CLOB, BYTE, VARBYTE, BLOB, BYTEINT, SMALLINT, INTEGER, BIGINT, FLOAT, REAL, DOUBLE PRECISION, DECIMAL, NUMBER, DATE, TIME, TIMESTAMP, TIME WITH TIME ZONE, TIMESTAMP WITH TIME ZONE, INTERVAL SECOND, INTERVAL MINUTE TO SECOND, INTERVAL MINUTE, INTERVAL HOUR TO SECOND, INTERVAL HOUR TO MINUTE, INTERVAL HOUR, INTERVAL DAY TO SECOND, INTERVAL DAY TO MINUTE, INTERVAL DAY TO HOUR, INTERVAL DAY, INTERVAL MONTH, INTERVAL YEAR TO MONTH, INTERVAL YEAR Column which needs to be unpivoted.
accumulate_column Any Column which needs to be copied to the output table.