Union
Stacks two tables on top of each other into one longer table. Columns are matched by name, so the two tables do not need identical layouts; a column present in only one of them is kept, with blanks for the rows that came from the other table.
Inputs
| Input | Accepts | Required |
|---|---|---|
Table1 | Table | Yes |
Table2 | Table | Yes |
Outputs
| Output | Produces |
|---|---|
Result | Table |
Example
You import Q1_Transactions and Q2_Transactions as separate tables, each with
Date, Account, and Amount. Connect both to a Union node and the result is a
single half-year transaction list, Q1 rows first, which appears as its own tab.
Follow with a GroupBy on Account to see six-month totals.
Tips
- Column names must match exactly for values to line up. Run RenameColumns
first if one file says
Amtand the other saysAmount. - To stack three or more tables, chain Unions: the result of one becomes an input to the next.
- If the same rows may appear in both tables, add a Deduplicate node after.