Shape · 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.

Also known as: Case when, if/else, conditional split

How it works

Cases is an ordered list; each case has a label and one condition written the way a Filter condition is, with a Value, Column or Expression on the right. A row is tested against the cases top to bottom and leaves through the first one whose condition is true; a condition that evaluates to NULL is no match. Rows matching no case leave through Default. Every case is its own output port, so you wire each branch separately; renaming or reordering a case keeps its wires, removing it removes them.

Inputs and outputs

Settings

{
  cases: [{ id?: string, label: string, condition: { column, operator: "="|"!="|">"|"<"|">="|"<="|"contains"|"is null"|"is not null"|"is empty"|"is not empty", value, rhsKind?: "value"|"column"|"expression", rhsColumn?, rhsExpression? } }]
}

Example

Size bands on amount, in this order so the widest test comes first:

More in 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.
• 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.