transformations:pivot
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
| transformations:pivot [2020/01/22 04:37] – dmitry | transformations:pivot [2020/01/22 04:38] – 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