Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r090

D toc

Excerpt

You can convert columns into rows of values.

...

A conversion transformations extracts the values from a specified column or columns and turns the column name and each extracted value into key-value pairs.

...

 

  • Unpivot can be applied to one or more columns.
  • Often, this transformation is applied to datasets containing pivoted or aggregated data. For more information, see Pivot Data.
Info

NOTE: Depending on the number of source columns, an unpivot operation can significantly increase the number of rows in your dataset.

...

Info

NOTE: You can use the asterisk ( * ) wildcard in the Columns textbox to apply the unpivot to the entire dataset, which generates a key and a value column, containing all column-row entries from the source columns. However, unpivoting a large number of columns can significantly increase the number of rows in your dataset.

D s also
inCQLtrue
label((label = "structuring_tasks") OR (label = "column_ui") OR (label = "unpivot"))