Category: Transform / Basic

This action calculates and replaces the values in one or more existing columns using expression(s). Each expression replaces one column.

• Apply standardized abbreviations to full-length text values (or full-length values to abbreviations).
• Removing prefixes or suffixes from text values.
• Convert formatting of imported values to align with a required destination schema.
• Correct common misspellings.
• Update outdated values.

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.

Replace students' final numeric grade with the equivalent letter grade.

Column to replace: Final grade
Expression: if [Final grade] >= 90 then "A" else if [Final grade] >= 80 then "B" else if [Final grade] >= 70 then "C" else if [Final grade] >= 60 then "D" else "F"

Calculate the dollar amount of compulsory deductions for each country, replacing the percent values with the dollar amounts.

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

• 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