Update Values
Update column values with expression
What It Does
Update Values changes values in an existing column or creates a new one using a SQL expression. Optionally apply only when a condition is met.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Update Values". It's in the Transform group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Expression | SQL expression | Yes | The value or formula to set |
Condition | Condition builder | No | Only update rows matching this condition |
Output | Apply Results Into | No | Write to existing column or create new one |
SQL Generated
SELECT *, CASE WHEN revenue > 1000 THEN 'high' ELSE 'low' END AS tier FROM dataNotes
- Null values are handled gracefully - operations skip or preserve nulls where appropriate.
- You can edit any pipeline step by clicking on its card to re-open the panel with the same settings.
- The SQL preview shows exactly what will execute - inspect it before applying.
Related Operations
- Find & Replace - Search and replace values in a column
- Text Transform - Transform text: uppercase, lowercase, trim
- Math - Arithmetic operations on columns