Formula

You can use this step to create a column as a formula based on other columns. 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 (%).

This step is supported by the following backends:

  • Mongo 5.0
  • Mongo 4.2
  • Mongo 4.0
  • Mongo 3.6
  • Pandas (python)

Where to find this step?

  • Widget Add and Compute
  • Search bar

Options reference

  • New column: the name of the new column to be created with the formula result.

  • Formula: the formula, which can be an algebraic formula composed of numbers, maths operators and columns; it can also be a text (escaped by quotes) to uniformly fill the column with that text.

Example 1: Basic usage

This configuration results in:

Example 2: Columnn names with whitespaces

This configuration results in: