User Tools

Site Tools


transformations:shiftcolumn

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
transformations:shiftcolumn [2021/04/23 01:25] craigttransformations:shiftcolumn [2021/07/19 02:18] (current) – [Examples] craigt
Line 22: Line 22:
 \\  \\ 
 =====Examples===== =====Examples=====
-**Objective:**  Calculate the delta with previous year. For this, we're appending a new column ("Prev. year sales"), shifted down by 1 row.\\+**Example:**  Calculate the delta with previous year. For this, we're appending a new column ("Prev. year sales"), shifted down by 1 row.\\
  
 **Source data:** Sales by year. **Source data:** Sales by year.
Line 41: Line 41:
  
 \\  \\ 
-**Result:**+**Result table:**
 ^  Year  ^  Sales  ^ Prev. year sales ^ ^  Year  ^  Sales  ^ Prev. year sales ^
 |  2010 |  10000|       | |  2010 |  10000|       |
Line 50: Line 50:
 |  2015 |  11300|   8500| |  2015 |  11300|   8500|
  
 +\\ 
 +====Community examples====
 +  * [[https://community.easymorph.com/t//1590/4|Puzzler: derived column from two columns]] ([[https://community.easymorph.com/uploads/short-url/5OvCYyhfiaCg5XZU3nALaT5eql4.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //4//)
 +  * [[https://community.easymorph.com/t//1686/2|Aggregation of consecutive date ranges]] ([[https://community.easymorph.com/uploads/short-url/xyC5nPd52hGrMiRXjp5w1RVUTYL.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Easymorph Patient Example Data.xlsx//;\\ Action position: //3//)
 +  * [[https://community.easymorph.com/t//1972/2|Read Data with two line header]] ([[https://community.easymorph.com/uploads/short-url/4YFQxslIv3pmgtF2eRywf4wpcFQ.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Read, Mark groups//; Action position: //8//)
  
transformations/shiftcolumn.txt · Last modified: 2021/07/19 02:18 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki