Skip to content

UNION

Usage

Use this function to get a new set calculated as A ∪ B

Category Function Type Where to use Argument statement
FUNCTION SERVER STORAGE VALUES LIST .VALUE

Syntax

1
=UNION(Parameter_1; Parameter_n)

Arguments

Parameter_1
any cell value (#Storage_Name.Field_Name.VALUE or .OLDVALUE), constant, System Variables or function-returned values list

Parameter_n
any cell value (#Storage_Name.Field_Name.VALUE or .OLDVALUE), constant, System Variables or function-returned values list

Return Value

List

Examples

Example 1

Formula
=UNION(LIST(1; 2);
=LOOKUPLIST(
#StorageExample;
#StorageExample.Column_1;
#StorageExample.Column_2 = "Approved")
)

Description
...

Result
...