TD_Pivoting Function | Pivoting | Teradata Vantage - TD_Pivoting - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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.

Function Information