{{ transformations:ReplaceColumnsAction.png}}
====== MODIFY COLUMN(S) ======
Category: Transform / Basic\\

\\ 
=====Description=====
This action calculates and replaces one or more existing columns using [[syntax:start|expression(s)]]. One expression replaces one column.\\

\\ 
=====Action settings=====
^Setting^Description^
|Column to replace|Select the name of the column to replace.|
|Expression or Value|Options:  //It's an expression// or //It's a text or number//.  Enter the expression used to calculate the updated\\ column values, or, enter the text or numeric value that will be repeated for all values.|
Click //Replace more columns// to modify additional columns within this same action.\\

\\ 
=====Remarks=====
You can refer to the same column in expressions. In this case, the original value from this column will be used.\\

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

**Example:** Calculate the $ amount of compulsory deductions for each country and include the result in the table instead of the deductions in %.

**Source table:** Average income and deductions

^Country  ^Gross income   ^Disposable income  ^Compulsory deductions  ^
| United States  |  56067|  45582|  18.7%|
| Australia  |  51050|  42617|  16.52%|
| Switzerland  |  53716|  48414|  9.87%|
| Canada  |  45896|  37469|  18.36%|
\\ 
**Action parameters:**
>Column to replace: Compulsory deductions
>Expression: ([Gross income] - [Disposable income])

\\ 
**Result table:**

^Country  ^Gross income   ^Disposable income  ^Compulsory deductions  ^
| United States  |  56067|  45582|  10485|
| Australia  |  51050|  42617|   8433|
| Switzerland  |  53716|  48414|  5302|
| Canada  |  45896|  37469|   8427|

\\ 
====Community examples====
  * [[https://community.easymorph.com/t//1221/2|Optional calculations with columns]] ([[https://community.easymorph.com/uploads/short-url/xdMJcC4iCkM1HopeOv5m0VqEuvh.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Optional calculation//; Action position: //3//)
  * [[https://community.easymorph.com/t//1398/1|How to obtain a list of all files recursively]] ([[https://community.easymorph.com/uploads/short-url/p5eGkU5ftaJpBXTfGbLxLte2VPX.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //3//)
  * [[https://community.easymorph.com/t//1749/2|Match action - matching multiple values]] ([[https://community.easymorph.com/uploads/short-url/klCJavldZpx8EQbvoCRW6a6cYlr.morph|Project]]; Module: //Get matches//; Group: //Tab 1//; Table: //Lookup table//; Action position: //4//)
  * [[https://community.easymorph.com/t//1882/3|Transforming Single Row of Data from CSV into Multiple Rows]] ([[https://community.easymorph.com/uploads/short-url/mEw4PYroNSO8QmJx0ykBvIuP6Ns.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //3//)
  * [[https://community.easymorph.com/t//2259/2|Reverse Fill-down]] ([[https://community.easymorph.com/uploads/short-url/2a52KxpNk99MGG3XA960vQ9U7LL.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //Table 2 (2)//; Action position: //3//)
  * [[https://community.easymorph.com/t//2580/6|Parsing Exceptionally Complex Column]] ([[https://community.easymorph.com/uploads/short-url/18twYeVICxpKyR13IU4TQn2MNnm.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //Table 1 (parsed)//; Action position: //3//)

\\ 
=====Shortcuts=====
Fast ways to create the action:\\
  *Right-click on a column heading, and select "Modify", then "With expression..." from the submenu.
  *Click the drop-down arrow in a column heading and select "Modify", then "With expression..." from the submenu.


\\ 
=====See also=====
  * [[transformations:addcolumn|Calculate new column(s)]]
  * [[transformations:rule|Rule]]