Unnest
Explode delimited column into rows
What It Does
Unnest splits a delimited column into multiple rows. If a cell contains "a,b,c" and you unnest by comma, you get three rows.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Unnest". It's in the Data group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Column | Column select | Yes | The column with delimited values |
Delimiter | Text | Yes | Character(s) to split on (e.g., comma) |
SQL Generated
SELECT *, UNNEST(string_split(tags, ',')) AS tag 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
- Fill Missing - Fill null values
- JSON Extract - Extract data in JSON format into columns