Filter Rows

The Filter Rows transform operation is used to filter out rows from the input based on a criterion.

Configuration

In the configuration section of the command, you specify the criteria using rules on columns. You can specify multiple criteria and join them using AND or OR operators. Criteria on several columns can be combined using AND or OR to form an expression and can also be grouped to form more complex filter expressions.

The operators used for each column depend on its type.

Example

The CSV export below had many null records. We used the Filter Rows command to remove the null records by specifying "is not null" criteria on the order_id column.

The filter removes any record where the order_id column is null.