User Tools

Site Tools


transformations:replacecolumn

Calculate and replace column(s)

This transformation calculates and replaces one or more existing columns using expression(s). One expression replaces one column.

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/replacecolumn.txt · Last modified: 2015/04/10 18:27 by elenap