TD_Pivoting Function | Pivoting | Teradata Vantage - TD_Pivoting - 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-10-04
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
lifecycle
latest
Product Category
Teradata Vantageā„¢

TD_Pivoting function is used to pivot the data, that is, changes the data from sparse to dense format.

TD_Unpivoting follows this process:
  1. Select a table with data in sparse format.
  2. Use TD_Pivoting to change data from sparse to dense format.
Therefore, you can convert data from sparse to dense format and vice versa. To do this you can use the following functions:
  1. TD_Unpivoting.
  2. TD_Pivoting.
TD_Pivoting function is aimed to be used in conjunction with other inDB analytic functions, in contrast to TD_Pivot.