Split Column
Split a column by delimiter into multiple
What It Does
Split Column breaks a text column into multiple columns using a delimiter. For example, split "John Smith" by space into first_name and last_name.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Split Column". It's in the Columns group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Column | Column select | Yes | The column to split |
Delimiter | Text | Yes | Character(s) to split on |
Number of parts | Number | Yes | How many columns to create |
SQL generated under the hood
SELECT *, split_part(full_name, ' ', 1) AS first_name, split_part(full_name, ' ', 2) AS last_name FROM dataRelated Operations
- Select Columns - Pick and reorder columns
- Delete Columns - Remove columns from the table
- Copy Columns - Duplicate columns with custom names