← All features

Canvas nodes

Union

Stack rows from several inputs with optional deduplication.

How it works

Connect tables to stack their rows. The first input determines the output columns, and you can enable duplicate removal for the combined rows.

Click Union on Canvas to open its settings and output. The rows from both inputs appear in one table.

Simple example

Connect two order tables with matching headers to Union. The output stacks the rows from both tables so they can be inspected together.

Union selected in n0is Canvas in the simple example.
n0is Canvas · Sample dataView full size

Input 1

2 rows
OrderIDAmount
A-119
A-232

Input 2

2 rows
OrderIDAmount
A-348
A-416

Node output

4 rows
OrderIDAmount
A-119
A-232
A-348
A-416

Complex workflow

Combine overlapping order exports that use the same schema. Turn on Remove duplicate rows to discard exact repeats, then sum Amount by Channel across the combined table.

Union selected in n0is Canvas in the complex workflow.
n0is Canvas · Sample dataView full size

Input 1

3 rows
OrderIDChannelAmount
A-1Online19
A-2Store32
A-3Online48

Input 2

4 rows
OrderIDChannelAmount
A-2Store32
A-3Online48
A-4Online16
A-5Store55

Node output

5 rows
OrderIDChannelAmount
A-1Online19
A-2Store32
A-3Online48
A-4Online16
A-5Store55

Workflow result

2 rows
Channelsum_Amount
Online83
Store87