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

SELECT *, first_name || ' ' || last_name AS full_name FROM data

Try this operation →

Notes

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

Select Columns - Pick and reorder columns
Delete Columns - Remove columns from the table
Copy Columns - Duplicate columns with custom names