Skip to main content
Skip table of contents

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:

YearEmployeeSalary
2019E150.000
2019E260.000


Node 2:

YearEmployeeSalary
2020E155.000
2020E266.000

After:

UNION('node1', 'node2') :

YearEmployeeSalary
2019E150.000
2019E260.000
2020E155.000
2020E266.000
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.