transformations:pivot
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:pivot [2016/06/19 19:56] – created dmitry | transformations:pivot [2020/01/22 04:38] – dmitry | ||
---|---|---|---|
Line 2: | Line 2: | ||
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: Winter Olympics medals** | ||
+ | |||
+ | ^ Country | ||
+ | | Canada | ||
+ | | United States | ||
+ | | Norway | ||
+ | | Germany | ||
+ | | Canada | ||
+ | | United States | ||
+ | | Norway | ||
+ | | Germany | ||
+ | |||
+ | |||
+ | Pivot on columns [Season] and [Medals]. Aggregation - Any. | ||
+ | |||
+ | Result: | ||
+ | ^ Country | ||
+ | | Canada | ||
+ | | United States | ||
+ | | Norway | ||
+ | | 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** | ||
+ | * [[transformations: |
transformations/pivot.txt · Last modified: 2021/07/19 02:23 by craigt