transformations:replacecolumn
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:replacecolumn [2015/04/10 14:25] – elenap | transformations:replacecolumn [2021/04/01 14:57] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Calculate and replace column(s) ===== | + | {{ transformations: |
+ | ====== MODIFY COLUMN(S) ====== | ||
+ | Category: Transform / Basic\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | Please note, that in expressions | + | Please note that you can refer to the same column |
- | EXAMPLE | ||
- | **Source table:** Average income and deductions | + | \\ |
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |Column to replace|Select the name of the column to replace.| | ||
+ | |Expression or Value|Options: // | ||
+ | Click //Replace more columns// to modify additional columns within this same action.\\ | ||
- | ^ Country | + | \\ |
- | | United States | + | =====Examples===== |
- | | Australia | + | |
- | | Switzerland | + | |
- | | Canada | + | |
**Objective: | **Objective: | ||
- | **Transformation parameters:** | + | **Source table:** Average income and deductions |
- | * Column to replace: Compulsory deductions | + | |
- | | + | ^Country |
+ | | United States | ||
+ | | Australia | ||
+ | | Switzerland | ||
+ | | Canada | ||
+ | |||
+ | **Action parameters: | ||
+ | >Column to replace: Compulsory deductions | ||
+ | >Expression: ([Gross income] - [Disposable income]) | ||
**Output table:** | **Output table:** | ||
- | ^ Country | + | ^Country |
- | | United States | + | | United States |
- | | Australia | + | | Australia |
- | | Switzerland | + | | Switzerland |
- | | Canada | + | | Canada |
- | + | ||
- | See also | + | |
+ | \\ | ||
+ | =====Shortcuts===== | ||
+ | Fast ways to create the action:\\ | ||
+ | *Right-click on a column heading, and select " | ||
+ | *Click the drop-down arrow in a column heading and select " | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
* [[transformations: | * [[transformations: | ||
+ |