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
Join
Keep column(s)
Percentage
Pivot
Rename
Replace
Sort
Split column
To lowercase
To uppercase
Top N rows
Unpivot
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
AddandCompute - 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 1: Basic usage
This configuration results in:
Example 2: Columnn names with whitespaces
This configuration results in:
