transformations:pivot
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:pivot [2016/06/19 20:01] – dmitry | transformations:pivot [2020/01/22 04:39] – dmitry | ||
---|---|---|---|
Line 3: | Line 3: | ||
Creates a matrix table using values in one column as column labels, and values in another column as the matrix column' | Creates a matrix table using values in one column as column labels, and values in another column as the matrix column' | ||
- | EXAMPLE | + | **Example: Winter Olympics medals** |
- | + | ||
- | **Table:** Winter Olympics medals | + | |
^ Country | ^ Country | ||
Line 18: | Line 16: | ||
- | **Transformation: | + | Pivot on columns [Season] and [Medals]. Aggregation - Any. Result: |
- | + | ||
- | **Result:** | + | |
^ Country | ^ Country | ||
| Canada | | Canada | ||
Line 26: | Line 22: | ||
| Norway | | Norway | ||
| Germany | | Germany | ||
+ | |||
+ | Note that grouping works implicitly in the " | ||
+ | |||
+ | If a pivoted dataset has only two columns, one of which is used for data, and the other for labels), then the resulting dataset will always have only 1 row. | ||
**See also** | **See also** | ||
* [[transformations: | * [[transformations: |
transformations/pivot.txt · Last modified: 2021/07/19 02:23 by craigt