Differences

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

--- transformations:replacecolumn [2015/01/29 23:06] – created dmitry
+++ transformations:replacecolumn [2015/04/10 14:27] – elenap
@@ Line 3: / Line 3: @@
 This transformation calculates and replaces one or more existing columns using [[syntax:start|expression(s)]]. One expression replaces one column.
-Please note, that in expressions you can refer to the same column. In this case previous (old) value from this column will be used.
+Please note that you can refer to the same column in expressions. In this case previous (old) value from this column will be used.
+EXAMPLE
+**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%  |
+**Objective:** Calculate the $ amount of compulsory deductions for each country and include the result in the table instead of the deductions in %.
+**Transformation parameters:**
+  * Column to replace: Compulsory deductions
+  * Expression: ([Gross income] - [Disposable income])
+**Output 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  |
 See also
   * [[transformations:addcolumn|Calculate new column(s)]]