Table of Contents

CALCULATE NEW COLUMN(S)

Category: Transform / Basic


Description

This action calculates one or more new columns using expression(s). One expression creates one column.


Use cases


Action settings

SettingDescription
New column nameEnter the name of the new column.
Expression or ValueOptions: It's an expression or It's a text or number. Enter the expression used to calculate the new column values,
or, enter the text or numeric value that will be repeated for all values.
PositionChoose where the new column(s) will appear in the dataset. Options: Rightmost, Leftmost, or After column
(and select the column the new column(s) will appear after).
If column already existsChoose how EasyMorph reacts if the new column name already exists in the dataset.
Options: Rename new column (a sequential number is appended to the column name), Do not create new column
(the column is not created and the workflow continues), or Fail (the action displays an error and the workflow stops).


Remarks

The expression is calculated for every row. Other column values in the same row can be referred to by column names in square brackets. It's not possible to refer to other rows or tables.

Instead of an expression, this action can insert a full column of static text or numeric values.

Subsequent expressions can reference columns previously created within the same Calculate new column(s) action. (See example, below)


Examples

Example #1: Calculate the $ amount of compulsory deductions for each country

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:

New column name: Deductions $
Expression: [Gross income] - [Disposable income]


Result table:

Country Gross income Disposable income Compulsory deductions Deductions $
United States 56067 45582 18.7% 10485
Australia 51050 42617 16.52% 8433
Switzerland 53716 48414 9.87% 5302
Canada 45896 37469 18.36% 8427




Example #2: Create multiple new columns within the same action.


Action parameters:

New column #1: MyDate = today()
New column #2: MyYear = year([MyDate]) (References the [MyDate] column previously created in this action.)


Community examples


Shortcuts

Fast ways to create the action:

In either case, a new column with a default column name will appear after the selected column.


See also