User Tools

Site Tools


transformations:pivot

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Last revisionBoth sides next revision
transformations:pivot [2021/04/24 16:55] craigttransformations:pivot [2021/07/18 22:50] craigt
Line 48: Line 48:
 > Aggregation method = "Any" > Aggregation method = "Any"
 \\  \\ 
-**Result:**+**Result table:**
 ^  Country  ^  winter 2010  ^  winter 2014  ^ ^  Country  ^  winter 2010  ^  winter 2014  ^
 | Canada  |  26  |  25  | | Canada  |  26  |  25  |
Line 54: Line 54:
 | Norway  |  23  |  26  | | Norway  |  23  |  26  |
 | Germany  |  30  |  19  | | Germany  |  30  |  19  |
 +
 +\\ 
 +====Community examples====
 +  * [[https://community.easymorph.com/t//1351/1|How to order columns by a list of columns]] ([[https://community.easymorph.com/uploads/short-url/bKeuXUgwKo1alDrA03LY5z3tPJv.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Reordered columns//; Action position: //3//)
 +  * [[https://community.easymorph.com/t//1716/2|Transpose with grouping]] ([[https://community.easymorph.com/uploads/short-url/voIH8WsKZnRm0MVr8UsSvfEDmC1.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Book1.xlsx//; Action position: //5//)
 +  * [[https://community.easymorph.com/t//1926/3|Sort column in an export alphabetically (tab)]] ([[https://community.easymorph.com/uploads/short-url/b1cFUp2TMl0yEassYLlT4oO3hxp.morph|Project]]; Module: //Main//; Group: //Enum/pivot/append//; Table: //Template table to append to//; Action position: //3//)
 +  * [[https://community.easymorph.com/t//2220/1|Example: obtaining stock price history from web API]] ([[https://community.easymorph.com/uploads/short-url/q46H2C6P5gxJt02P2TexolJXvBK.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //Stock history//; Action position: //8//)
 +  * [[https://community.easymorph.com/t//2321/4|Collapsing multiple rows into one]] ([[https://community.easymorph.com/uploads/short-url/j6CBEKHa76q1v9oQqui4UPWN7ro.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //Method 1//; Action position: //4//)
  
 \\  \\ 
 =====See also===== =====See also=====
   * [[transformations:unpivot|Unpivot]]   * [[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