transformations:unpivot
This is an old revision of the document!
Unpivot
Converts a matrix table into a straight table by rotating columns into [Labels] and [Data] columns. This transformation is opposite to the Pivot action.
EXAMPLE
Table: Winter Olympics medals
| Country | winter 2010 | winter 2014 |
|---|---|---|
| Canada | 26 | 25 |
| United States | 37 | 28 |
| Norway | 23 | 26 |
| Germany | 30 | 19 |
Transformation: Unpivot
Result:
| Country | Labels | Data |
|---|---|---|
| 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 |
See also
transformations/unpivot.1538594317.txt.gz · Last modified: by dmitry