{{ transformations:ShiftColumnAction.png}}
======SHIFT COLUMN UP/DOWN======
Category: Transform / Advanced \\

\\ 
=====Description=====
This action shifts values in the specified column up or down. When a column is shifted down, empty cells are inserted at the top of the column. When shifted up, empty cells are inserted at the bottom.\\

\\ 
=====Use cases=====
This action can be used in cases when a comparison with a previous/future period is required.\\

\\ 
=====Action settings=====
^Setting^Description^
|Column|Select the column shift.|
|Shift direction|Select whether the column's rows will be shifted up or down.  Options: //Up// or //Down//.|
|Shift by N rows<sup>*</sup>|Select or enter the number of rows to be shifted by.|
|Mode|Select whether the results of this action will overwrite the selected column's content, or if a new column will be created.\\ Options: //Create new column// (and provide a column name) or //Replace column//.|
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].

\\ 
=====Examples=====

====Example #1====
>Calculate the delta with the previous year. Append a new column ("Prev. year sales"), shifted down by 1 row.\\

===Before (source data)===
^  Year  ^  Sales  ^
|  2010 |  10000|
|  2011 |  12100|
|  2012 |   9000|
|  2013 |  11000|
|  2014 |   8500|
|  2015 |  11300|

===After (result table)===
^  Year  ^  Sales  ^ Prev. year sales ^
|  2010 |  10000|       |
|  2011 |  12100|  **10000**|
|  2012 |   9000|  **12100**|
|  2013 |  11000|   **9000**|
|  2014 |   8500|  **11000**|
|  2015 |  11300|   **8500**|

===Action parameters===
> Column: Sales
> Shift direction: Down
> Shift by: 1 row
> Mode: Create new column (Prev. year sales)

\\ 
=====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//)