User Tools

Site Tools


transformations:pivot

Differences

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

Link to this comparison view

Next revision
Previous revision
Next revisionBoth sides next revision
transformations:pivot [2016/06/19 19:56] – created dmitrytransformations:pivot [2016/06/19 20:01] 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**
 +  * [[transformations:unpivot|Unpivot]]
transformations/pivot.txt · Last modified: 2021/07/19 02:23 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki