Combine Columns
Combine columns and text into one
What It Does
Combine Columns concatenates multiple columns and literal text into a single column. For example, combine first_name and last_name into full_name with a space separator.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Combine Columns". It's in the Columns group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Parts | Column/text list | Yes | Columns and literal text to combine, in order |
Output | Apply Results Into | No | Write to existing or new column |
SQL generated under the hood
SELECT *, first_name || ' ' || last_name AS full_name FROM dataRelated Operations
- Select Columns - Pick and reorder columns
- Delete Columns - Remove columns from the table
- Copy Columns - Duplicate columns with custom names