User Tools

Site Tools


transformations:pivot

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
transformations:pivot [2020/01/22 04:37] dmitrytransformations: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's values. This transformation is opposite to [[transformations:unpivot|Unpivot]]. Creates a matrix table using values in one column as column labels, and values in another column as the matrix column's values. This transformation is opposite to [[transformations:unpivot|Unpivot]].
  
-EXAMPLE +**Example: Winter Olympics medals**
- +
-**Table:** Winter Olympics medals+
  
 ^  Country  ^  Season  ^  Medals  ^ ^  Country  ^  Season  ^  Medals  ^
Line 18: Line 16:
  
  
-**Transformation:** Pivot on columns [Season] and [Medals]. Aggregation - Any. +Pivot on columns [Season] and [Medals]. Aggregation - Any. Result:
- +
-**Result:**+
 ^  Country  ^  winter 2010  ^  winter 2014  ^ ^  Country  ^  winter 2010  ^  winter 2014  ^
 | Canada  |  26  |  25  | | Canada  |  26  |  25  |
transformations/pivot.txt · Last modified: 2021/07/19 02:23 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki