transformations:replacecolumn
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:replacecolumn [2015/01/29 23:06] – created dmitry | 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 |
- | See also | + | |
+ | \\ | ||
+ | =====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.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | **Objective: | ||
+ | |||
+ | **Source table:** Average income and deductions | ||
+ | |||
+ | ^Country | ||
+ | | United States | ||
+ | | Australia | ||
+ | | Switzerland | ||
+ | | Canada | ||
+ | |||
+ | **Action parameters: | ||
+ | >Column to replace: Compulsory deductions | ||
+ | > | ||
+ | |||
+ | |||
+ | **Output table:** | ||
+ | |||
+ | ^Country | ||
+ | | United States | ||
+ | | Australia | ||
+ | | Switzerland | ||
+ | | Canada | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====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: | ||
+ |