User Tools

Site Tools


transformations:replacecolumns

MODIFY COLUMN(S)

Category: Transform / Basic


Description

This action calculates and replaces one or more existing columns using expression(s). One expression replaces one column.


Action settings

SettingDescription
Column to replaceSelect the name of the column to replace.
Expression or ValueOptions: It's an expression or It's a text or number. Enter the expression used to calculate the updated
column values, or, enter the text or numeric value that will be repeated for all values.

Click Replace more columns to modify additional columns within this same action.


Remarks

You can refer to the same column in expressions. In this case, the original value from this column will be used.


Examples

Example: Calculate the $ amount of compulsory deductions for each country and include the result in the table instead of the deductions in %.

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%


Action parameters:

Column to replace: Compulsory deductions
Expression: ([Gross income] - [Disposable income])


Result table:

Country Gross income Disposable income Compulsory deductions
United States 56067 45582 10485
Australia 51050 42617 8433
Switzerland 53716 48414 5302
Canada 45896 37469 8427


Community examples


Shortcuts

Fast ways to create the action:

  • Right-click on a column heading, and select "Modify", then "With expression…" from the submenu.
  • Click the drop-down arrow in a column heading and select "Modify", then "With expression…" from the submenu.


See also

transformations/replacecolumns.txt · Last modified: 2021/07/19 01:19 by craigt