Union All
Append rows from another loaded table
What It Does
Union All stacks two tables vertically. All rows from the current table are kept, then rows from the second table are appended. The two tables should have compatible columns (same names and types in the same order). Useful for combining month-by-month files into a single dataset.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Union All". It's in the Data group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Other table | Table picker | Yes | Pick another table already loaded in your workspace |
Track source column | Toggle | No | Adds _source column recording origin table name |
SQL generated under the hood
SELECT *, 'jan' AS _source FROM jan_data UNION ALL SELECT *, 'feb' AS _source FROM feb_dataRelated Operations
- Join - Join with another file/table
- Unnest - Explode delimited column into rows
- Fill Missing - Fill null values