Copy Columns
Duplicate columns with custom names
What It Does
Copy Columns duplicates one or more columns with new names. Useful for preserving original data before transformations.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Copy Columns". It's in the Columns group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Copies | List | Yes | Source column and new column name pairs |
SQL Generated
SELECT *, name AS name_backup, price AS original_price 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
- Select Columns - Pick and reorder columns
- Delete Columns - Remove columns from the table
- Combine Columns - Combine columns and text into one