transformations:replacecolumn
This is an old revision of the document!
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 in expressions you can refer to the same column. 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.1428690352.txt.gz · Last modified: 2015/04/10 14:25 by elenap