transformations:addcolumn
This is an old revision of the document!
Calculate new column(s)
This transformation calculates one or more new columns using expression(s). One expression creates one column.
Expression is calculated for every row. Other column values in the same row can be referred by column names in square brackets. It's not possible to refer from one row to another row or to another table.
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
Transformation parameters:
- New column name: Deductions $
- Expression: ([Gross income] - [Disposable income])
Output table:
Country | Gross income | Disposable income | Compulsory deductions | Deductions $ |
---|---|---|---|---|
United States | 56067 | 45582 | 18.7% | 10485 |
Australia | 51050 | 42617 | 16.52% | 8433 |
Switzerland | 53716 | 48414 | 9.87% | 5302 |
Canada | 45896 | 37469 | 18.36% | 8427 |
See also
transformations/addcolumn.1428689798.txt.gz · Last modified: 2015/04/10 14:16 by elenap