TD_Pivoting Input - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢

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 MINNUTE,INTERVAL HOUR,INTERVAL DAY TO SECOND,INTERVAL DAY TO MINNUTE,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.