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 revision Previous revision
transformations:pivot [2016/06/19 23:58]
dmitry
transformations:pivot [2016/06/20 00:01] (current)
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'​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
 +
 +**Table:** Winter Olympics medals
 +
 +^  Country ​ ^  Season ​ ^  Medals ​ ^
 +| Canada ​ |  winter 2010  |  26  |
 +| United States ​ |  winter 2010  |  37  |
 +| Norway ​ |  winter 2010  |  23  |
 +| Germany ​ |  winter 2010  |  30  |
 +| Canada ​ |  winter 2014  |  25  |
 +| United States ​ |  winter 2014  |  28  |
 +| Norway ​ |  winter 2014  |  26  |
 +| Germany ​ |  winter 2014  |  19  |
 +
 +
 +**Transformation:​** Pivot on columns [Season] and [Medals]. Aggregation - Any.
 +
 +**Result:**
 +^  Country ​ ^  winter 2010  ^  winter 2014  ^
 +| Canada ​ |  26  |  25  |
 +| United States ​ |  37  |  28  |
 +| Norway ​ |  23  |  26  |
 +| Germany ​ |  30  |  19  |
  
 **See also** **See also**
   * [[transformations:​unpivot|Unpivot]]   * [[transformations:​unpivot|Unpivot]]
transformations/pivot.txt · Last modified: 2016/06/20 00:01 by dmitry