transformations:addcolumn
Differences
This shows you the differences between two versions of the page.
Next revisionBoth sides next revision | |||
transformations:addcolumn [2015/01/29 23:02] – created dmitry | transformations:addcolumn [2015/04/10 14:16] – elenap | ||
---|---|---|---|
Line 4: | Line 4: | ||
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. | 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 | ||
+ | | United States | ||
+ | | Australia | ||
+ | | Switzerland | ||
+ | | Canada | ||
+ | |||
+ | **Objective: | ||
+ | |||
+ | **Transformation parameters: | ||
+ | * New column name: Deductions $ | ||
+ | * Expression: ([Gross income] - [Disposable income]) | ||
+ | |||
+ | **Output table:** | ||
+ | |||
+ | ^ Country | ||
+ | | United States | ||
+ | | Australia | ||
+ | | Switzerland | ||
+ | | Canada | ||
+ | |||
See also | See also | ||
* [[transformations: | * [[transformations: |
transformations/addcolumn.txt · Last modified: 2024/02/05 14:20 by craigt