Skip to main content

Filter

The filter operator accepts a dataframe and creates a set of filter conditions based on it. Multiple filter conditions can be applied at once, and the filter conditions can be combined with AND or OR logical operators.

The filter operator has 2 outputs:

  • A dataframe, which applies the specified filter to the input dataframe
  • A filter output, which can be used to apply the filter to other dataframes.

Currently, the following types of filter conditions are supported:

Data TypeOperator
String

equals

contains

contains any

contains all

starts with

ends with

does not contain

is null

is not null

is empty

Numeric

equals (==)

does not equal (!=)

greater than (>)

greater than or equal to (>=)

less than (<)

less than or equal to (<=)

range

is null

is not null

Date

is

before

on or before

after

on or after

range

is null

is not null

Boolean

is

is not

is null

is not null