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