transformations:replacecolumn
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:replacecolumn [2021/04/01 14:57] – craigt | transformations:replacecolumn [2021/04/02 02:09] (current) – removed craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | {{ transformations: | ||
- | ====== MODIFY COLUMN(S) ====== | ||
- | Category: Transform / Basic\\ | ||
- | |||
- | \\ | ||
- | =====Description===== | ||
- | This action calculates and replaces one or more existing columns using [[syntax: | ||
- | |||
- | Please note that you can refer to the same column in expressions. In this case, the original value from this column will be used.\\ | ||
- | |||
- | |||
- | \\ | ||
- | =====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: | ||