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)
Column1 | Column2 | Column3 | Column4 | INTERSECTION returns |
---|---|---|---|---|
[1, 2, 3, 4] | [3, 4, 5] | [1, 2, 3, 4, 5] | [3, 3, 4, 4] | [3, 4] |