transformations:unpivot
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:unpivot [2021/04/28 14:33] – [Use cases] dmitry | transformations:unpivot [2021/07/19 02:16] (current) – [Examples] 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 24: | Line 24: | ||
\\ | \\ | ||
=====Examples===== | =====Examples===== | ||
- | **Objective:** Convert the matrix table, below, into a standard data table.\\ | + | **Example:** Convert the matrix table, below, into a standard data table.\\ |
\\ **Source table:** Winter Olympics medals | \\ **Source table:** Winter Olympics medals | ||
^Country | ^Country | ||
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