Formula

User interface

General Principles Add text column Aggregate Append Argmax Argmin Concatenate columns Convert Extract date property Delete column(s) Duplicate Fill null Filter Formula Join Keep column(s) Percentage Pivot Rename Replace Sort Split column Extract substring To lowercase To uppercase Top N rows Unpivot Get unique groups/values

Technical documentation

Steps Stepforms 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 or any other escaping character.

Warning: we do not support column names including whitespaces at the moment. So please apply a rename step beforehand if needed. (For example rename my column into my_column)

You can also specify a text escaped by quotes. It will then write the specified text in every row of the new column.

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

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.
New column: the name of the new column to be created with the formula result.

Example

This configuration results in: