Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision |
transformations:pivot [2021/04/24 16:55] – craigt | transformations:pivot [2021/07/18 22:50] – craigt |
---|
> 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 | |
| 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]] |