Join
Union Rows
Stacks two tables and keeps each row once, the way SQL UNION does.
When to use it
Use it to combine two lists of the same kind — this month's and last month's sign-ups — without the people who appear in both turning up twice.
In a pipeline
File InputUnion RowsExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Compare Using | select | — | Every column both tables have |
| Ignore upper and lower case | checkbox | — | false |
Example
Two mailing lists, one clean list
- Compare Using=Email
| Table | |
|---|---|
| A | ada@x.com |
| A | ben@x.com |
| A | cy@x.com |
| B | ben@x.com |
| B | dee@x.com |
| ada@x.com |
| ben@x.com |
| cy@x.com |
| dee@x.com |
Rows keep the order they arrived in: all of A, then whatever B adds.
Worth knowing
- To keep every row, duplicates and all, use Merge Rows instead — that is SQL's UNION ALL.
- Compare Using decides what counts as the same row. Left empty, every column the two tables share is compared.
- The result carries the columns of both tables; a row that lacks one of them shows a blank there.
- Tick Ignore upper and lower case to treat "ADA@X.COM" and "ada@x.com" as one row. Values are compared as text, with surrounding spaces ignored.