INTERSECTION

Syntax

INTERSECTION(<list>;<list>;...)

Description

Returns the intersection of all list arguments. The resulting list contains only the elements found in all the list arguments and doesn't contain any duplicate elements.

Example

INTERSECTION(Column1;Column2;Column3;Column4)

Column1Column2Column3Column4INTERSECTION returns
[1, 2, 3, 4][3, 4, 5][1, 2, 3, 4, 5][3, 3, 4, 4][3, 4]