Formula

User interface

General Principles Add text column Aggregate Append Argmax Argmin Concatenate columns Convert Convert date to text Convert text to date Cumulated sum Cutom step Delete column(s) Duplicate Evolution Extract date property Extract substring Fill null Filter Formula Get unique groups/values Hierarchical rollup ifthenelse Join Keep column(s) Percentage Pivot Rank Rename Replace Sort Split column Column's Statistics To lowercase To uppercase Top N rows Unpivot Waterfall

Technical documentation

Steps Designing a new step Known limitations Translators Variables Custom code editor

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.

This step is supported by the following backends:

Mongo 4.0
Mongo 3.6

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: