Shape · Rows

Filter

Keeps only the rows that meet your conditions, combined with AND or OR. For example, keep orders where the amount is over 100.

Also known as: Where, select records

How it works

Each row of Conditions names a column, an operator and what to compare against. The operators are =, ≠, >, <, ≥, ≤, contains, is null, is not null, is empty, is not empty, is in params and is not in params. The right-hand side can be a Value, another Column, an Expression (raw boolean SQL used as the whole condition, such as amount > target * 1.1) or a Param read from the first row of the table wired to the params handle. The conditions are combined with AND or OR. contains is a substring match; is empty matches NULL or an empty string, so use it for blank checks rather than a blank value, which leaves the condition unset. A half-filled condition stops the node from running, and no conditions at all passes every row.

Inputs and outputs

Settings

{
  conditions: [{ column, operator: "="|"!="|">"|"<"|">="|"<="|"contains"|"is null"|"is not null"|"is empty"|"is not empty"|"in"|"not in", value, rhsKind?: "value"|"column"|"expression"|"param", rhsColumn?, rhsExpression?, rhsParamColumn? }]
  combinator: "AND"|"OR"
}

Example

Keep paid EU orders over 100: status = paid, region = EU, amount > 100, combined with AND.

More in Rows

• Switch — Sends each row down one of several outputs: it goes to the first case whose condition is true, and rows that match none go to Default.
• Sort — Puts rows in order by one or more columns, ascending or descending, with blanks first or last.
• Row Limit — Keeps or drops the first or last N rows, in their current order. For example, skip three header lines or take 100 rows for a quick check.
• Top / Bottom N — Keeps the N rows with the largest or smallest values in one column, such as the 10 best-selling products. You choose what happens to ties at the cut-off.
• Distinct — Keeps one row per unique combination of key columns. You choose whether the first or last copy survives; with no keys it drops exact duplicate rows.
• Random Sample — Picks a random set of rows, either a fixed number or a share such as 10%. You can sample with replacement, or stratify by a column so each group keeps its share. Set a seed to get the same rows every time.
• Random Split — Divides rows into named groups by percentage, each on its own output, such as 80/20 train and test. Repeatable, and can keep each group's share of a column.
• Add Row Number — Numbers the rows 1, 2, 3… in a new column. You can sort first and restart the count in each group.
• Rank — Ranks rows by one or more columns, optionally within groups, so the top seller per region gets 1. You choose how ties are ranked; percentile rank is available too, and Tile splits the rows into N equal-sized buckets.
• Densify — Adds the rows that are missing so every key combination appears, taken from the data or from a reference table you wire in, and fills the gaps with values you choose. For example, every product for every month, with 0 sales where none were recorded.
• Generate Rows — Repeats each row once per value of a range, such as 1 to a count column or a start date to an end date, and adds the generated value as a column. For a sequence with no input, use Generate Series.