Add Column
Add a new computed or empty column
What It Does
Add Column creates a new column using a SQL expression. Write formulas like "price * quantity" or use functions like "UPPER(name)".
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Add Column". It's in the Columns group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Column name | Text | Yes | Name for the new column |
Expression | SQL expression | Yes | SQL expression to compute the value |
SQL Generated
SELECT *, price * quantity AS total 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
- Copy Columns - Duplicate columns with custom names