transformations:unpivot
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
transformations:unpivot [2021/04/28 14:33] – [Use cases] dmitry | transformations:unpivot [2021/07/18 23:48] – craigt | ||
---|---|---|---|
Line 9: | Line 9: | ||
\\ | \\ | ||
=====Use cases===== | =====Use cases===== | ||
- | This action is used to convert a cross-table (or matrix) into a straight table. It can be used for instance to convert a cross-table from an Excel spreadsheet into a table suitable for exporting into a database. | + | This action is used to convert a cross-table (or matrix) into a straight table. It can be used, for instance, to convert a cross-table from an Excel spreadsheet into a table suitable for exporting into a database. |
\\ | \\ | ||
Line 37: | Line 37: | ||
> Unpivot all columns except these = " | > Unpivot all columns except these = " | ||
\\ | \\ | ||
- | **Result:** | + | **Result |
^Country | ^Country | ||
| Canada | | Canada | ||
Line 52: | Line 52: | ||
If no columns were selected under " | If no columns were selected under " | ||
- | **Result:** | + | **Result |
^Labels | ^Labels | ||
|Country | |Country | ||
Line 67: | Line 67: | ||
|winter 2014 | 19| | |winter 2014 | 19| | ||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
\\ | \\ |
transformations/unpivot.txt · Last modified: 2021/07/19 02:16 by craigt