UNION

Basic Overview

AVAILABLE SINCE 5.1.0

Description	The UNION function is used to combine the result-sets of two or more input nodes.
Signature	UNION('Node1', 'Node2' [, 'Node3'])
Parameters	'Node1', 'Node2' [, 'Node3'] are nodes you want to combine the calculation result.
Limitations	inputs must have same levels inputs must not have overlapping rows

The UNION formula is a more restrictive version of the ADDITION formula.

While the ADDITION formula allows nodes with different levels to be combined, the UNION formula only allows nodes with the same levels to be combined.

That can, in some cases, be used as an extra validation as the inputs are required to have the same levels.

Example

Before:

Node 1:

Year	Employee	Salary
2019	E1	50.000
2019	E2	60.000

Node 2:

Year	Employee	Salary
2020	E1	55.000
2020	E2	66.000

After:

UNION('node1', 'node2') :

Year	Employee	Salary
2019	E1	50.000
2019	E2	60.000
2020	E1	55.000
2020	E2	66.000