User Tools

Site Tools


transformations:unpivot

Unpivot

Converts a matrix table into a straight table by rotating columns into [Labels] and [Data] columns. This transformation is opposite to Pivot transformation.

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.txt · Last modified: 2016/06/20 00:02 by dmitry