Add formula column
The Formula step allows you to create a new column in your dataset by applying a custom formula to existing columns.
Step parameters
New Column
(string)*: Specify the name for the new column that will contain the result of your formula.Formula
*: Enter the formula you want to apply. This can be a mathematical expression, a string manipulation, or a combination of functions. You can reference existing columns in your formula.
Example
Input

Configuration
{
"new_column": "monthly_salary",
"formula": "salary/12"
}
Output

A column can be referenced by its name without quotes unless they include whitespaces, in such a case you need to use brackets ‘[]’ (e.g. [myColumn]
).
Any characters string escaped with quotes (simple or double) will be considered as a string.
The supported operators are : addition (+
), substraction (-
), multiplication (*
), division (/
), modulo (%
).
Last updated
Was this helpful?