Help center Get started Knowledge center Product documentation API documentation
Product
Lens Weave Maskbits
Overview
Data
Data Import Output Result
Data Preparation
Cleansing Imputation Duplicates Filter Fuzzy Filter Outlier Treatment Binning Trimming Validation Sorting
Transformation
Data Transformation Bulk Data Transformation Merge Union Fuzzy Merge Encoding Normalization Scaling Standardization Aggregate Unpivot Functional Transformation SQL Executor
Statistical Plots
Box Plot Correlation Histogram Pair Wise Line Plot Scatter Plot Bar Plot Stem Plot Step Plot Fill Between Stack Plot Descriptive Statistics
Workflow Agent
Workflow Agent
Scheduler
Scheduler
Library
My Workflows Shared Workflows Audit
Datasource
Datasource
Datasource Management
Data Model
Connectors Management
Admin
Admin
User Management Roles Management Group Management Organization Management

Overview

The Filter node is a data preparation node in a Weave workflow that keeps rows matching a configured filter expression and discards the rest. The filter expression is built in a Filter Criteria popup as one or more conditional rows (Column / Filter Condition / Input) within one or more groups, with per-row Logic (AND / OR) operators combining adjacent rows. Thirteen Filter Condition operators are supported, covering equality, set membership, ordering comparisons, pattern matching, emptiness, and null checking.

Filter nodes are added from the Data Preparation category of the node panel. The Filter Criteria UI used here is the canonical filter-builder for the platform — the same UI appears in the Duplicates node’s Filter Table option.

Note: “Weave” is the current name for what earlier interface versions called “Workflow.” This reference uses “Weave.”

When to use it

  • Restricting a dataset to rows matching specific criteria — only US customers, only Q4 transactions, only active records.
  • Building exclusion logic — Not Equals, Not In, Not Null — to remove unwanted rows.
  • Compound filter expressions where multiple criteria must combine — Country = Canada AND Profit > 10000.
  • Null and emptiness handling — restricting to rows where a specific column has (or doesn’t have) a value.

Filter Condition operators

Thirteen operators are supported. Pick the operator appropriate to the column’s data type and the matching semantics required.

EqualsRow passes if the column’s value equals the Input.
Not EqualsRow passes if the column’s value does not equal the Input.
InRow passes if the column’s value is in the list of Input values.
Not InRow passes if the column’s value is not in the list.
Less ThanRow passes if the column’s value is strictly less than the Input. Numeric or comparable types.
Greater ThanRow passes if the column’s value is strictly greater than the Input.
Less Than Or Equal ToRow passes if the column’s value is less than or equal to the Input. Inclusive.
Greater Than Or Equal ToRow passes if the column’s value is greater than or equal to the Input. Inclusive.
LikeRow passes if the column’s value matches the pattern in the Input.
EmptyRow passes if the column’s value is empty.
Not EmptyRow passes if the column’s value is not empty.
NullRow passes if the column’s value is null (missing).
Not NullRow passes if the column’s value is not null.

Filter Criteria popup structure

The Filter Criteria popup is the standard filter-building interface across the platform. The same UI is used in various places. The popup contains one or more groups, each containing one or more conditional rows.

Row structure (within a group)

LogicCombines this row with the row above. AND or OR. Appears only on the second row onward — the first row has no Logic selector since it has no preceding row to combine with.
ColumnDropdown listing all upstream columns. Pick the column to filter on.
Filter ConditionDropdown listing the 13 operators. Pick the comparison.
InputValue(s) to compare against. Disabled or ignored for operators that don’t need a value (Empty, Not Empty, Null, Not Null).
Action+ icon (add another row below) and trash icon (delete this row — appears on rows 2+ only).

Group structure

+ Add GroupCreates a new group below the existing ones. Groups allow nested logic — (A AND B) OR (C AND D)-style expressions that can’t be expressed within a single group’s flat row list.
Delete GroupRemoves the group it labels. Each group has its own Delete Group button.

Key behaviors

Filter keeps matching rows, drops non-matching. A row passes the filter only if it matches the criteria. Non-matching rows are removed from the output.

Per-row Logic, not global. Within a group, each row after the first has its own Logic selector (AND or OR) that combines it with the row above. This is more powerful than a single global AND/OR across all rows — it lets the Designer write expressions like “A AND B OR C” where the AND applies between rows 1 and 2 and the OR applies between rows 2 and 3.

Filter Condition operators cover thirteen common comparison patterns. The 13-operator set covers equality (Equals / Not Equals), set membership (In / Not In), ordering (Less Than / Greater Than / Less Than Or Equal To / Greater Than Or Equal To), pattern matching (Like), emptiness (Empty / Not Empty), and null-checking (Null / Not Null). Most analytical filtering needs are expressible within this set; combinations via Logic + groups handle the remainder.

Null and Empty are distinct. Null matches missing values (the cell wasn’t populated); Empty matches values that exist but contain no content (typically the empty string “”). A column with both nulls and empty strings has different row counts under Null vs. Empty filters. Use Null / Not Null for missing-value handling; Empty / Not Empty for explicit zero-length string handling.