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 vice versa. 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.