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 [2020/01/22 04:37] – 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 |
transformations/pivot.txt · Last modified: 2021/07/19 02:23 by craigt