MODIFY COLUMN(S)

Category: Transform / Basic

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

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

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

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

Action parameters:

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

Result table:

• Optional calculations with columns (Project; Module: Main; Group: Tab 1; Table: Optional calculation; Action position: 3)
• How to obtain a list of all files recursively (Project; Module: Main; Group: Tab 1; Table: Table 1; Action position: 3)
• Match action - matching multiple values (Project; Module: Get matches; Group: Tab 1; Table: Lookup table; Action position: 4)
• Transforming Single Row of Data from CSV into Multiple Rows (Project; Module: Main; Group: Tab 1; Table: Table 1; Action position: 3)
• Reverse Fill-down (Project; Module: Main; Group: Group 1; Table: Table 2 (2); Action position: 3)
• Parsing Exceptionally Complex Column (Project; Module: Main; Group: Group 1; Table: Table 1 (parsed); Action position: 3)

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.

• Calculate new column(s)
• Rule