You can use this step to filter rows based on one or several conditions. At the
moment, we only support
and as logical link between conditions.
This step is supported by the following backends:
- Mongo 4.0
- Mongo 3.6
Where to find this step?
- Column header menu
- Search bar
Values in ...: the target column
Must...: a comparison operator (equal, not equal etc.)
Then you can enter value(s) to be compared to. For
be one ofand
not be one ofoperators, you can enter several values. For the
not be nulloperators, you do not need to enter any value as it is a comparison aginst
notmatchesoperators are used to test value against a regular expression.
Add condition: use this button if you need to add a new condition line. The retained rows will be those match every condition (logical
This configuration results in: