User Tools

Site Tools


transformations:unpivot

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:unpivot [2016/06/19 19:57] dmitrytransformations:unpivot [2018/10/03 15:18] dmitry
Line 1: Line 1:
 ===== Unpivot ===== ===== Unpivot =====
  
-Converts a matrix table into a straight table by rotating columns into [Labels] and [Data] columns. This transformation is opposite to [[transformations:pivot|Pivot]] transformation.+Converts a matrix table into a straight table by rotating columns into [Labels] and [Data] columns. This transformation is opposite to the [[transformations:pivot|Pivot]] action.
  
 EXAMPLE EXAMPLE
Line 13: Line 13:
 | Germany  |  30  |  19  | | Germany  |  30  |  19  |
  
-**Transformation:** Calculate+**Transformation:** Unpivot
  
 **Result:** **Result:**
transformations/unpivot.txt · Last modified: 2021/07/19 02:16 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki