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 revisionBoth sides next revision
transformations:unpivot [2021/04/24 17:20] craigttransformations:unpivot [2021/04/28 14:33] – [Use cases] dmitry
Line 9: Line 9:
 \\  \\ 
 =====Use cases===== =====Use cases=====
-This action is used to convert a cross-tabular table into a normalized data table suited for database usage.+This action is used to convert a cross-table (or matrix) into a straight table. It can be used for instance to convert a cross-table from an Excel spreadsheet into a table suitable for exporting into a database.
  
 \\  \\ 
transformations/unpivot.txt · Last modified: 2021/07/19 02:16 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki