Fill Missing
Fill null values
What It Does
Fill Missing replaces null/empty values in a column. Use a literal value, or fill forward (use previous row's value) or backward (use next row's value).
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Fill Missing". It's in the Data group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Column | Column select | Yes | The column with missing values |
Method | Select | Yes | literal (set value), forward (previous row), backward (next row) |
Value | Text | For literal | The value to fill with |
SQL Generated
SELECT *, COALESCE(status, 'unknown') AS status 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
- Join - Join with another file/table
- Unnest - Explode delimited column into rows
- JSON Extract - Extract data in JSON format into columns