TD_Pivoting Input - Teradata VantageCloud Lake

Lake - Analyze Your Data with ClearScape Analytics™

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2026-02-20
dita:mapPath
tcl1683670667798.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
tcl1683670667798

InputTable Schema

Column Data Type Description
partition_column Any allowed by PARTITION BY clause [Column appears one time for each specified partition_column.] Column to which to partition input data.
target_column CHAR,VARCHAR,BYTE,VARBYTE,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 DAYINTERVAL MONTH,INTERVAL YEAR TO MONTH,INTERVAL YEAR Column to be pivoted.
accumulate_column Any [Column appears one time for each specified partition_column.] Column to copy to output table from input table.