Join
Merge Rows
Stacks the rows from all of its inputs into one table without matching or removing anything.
When to use it
Use it to recombine the True and False branches of a filter, or to pool several sources that share the same shape into one stream.
In a pipeline
Filter RowsMerge RowsExport CSV
Example
Pool web and retail orders
| Order | Channel | Amount |
|---|---|---|
| A-1 | Web | 120 |
| A-2 | Web | 80 |
| Order | Channel | Amount |
|---|---|---|
| A-1 | Web | 120 |
| A-2 | Web | 80 |
| R-7 | Retail | 45 |
Input B contributes R-7, which is appended after the rows from input A.
Worth knowing
- The node has no settings; it appends the inputs in the order they are connected.
- This is a union that keeps everything, so add Remove Duplicates after it if the sources overlap.
- Inputs with different columns are still merged, and rows that lack a column show blank there.
- It is the usual way to bring a Filter Rows True and False branch back together.