Page History
This is best illustrated with the following examples.
Panel | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||
SYMMETRIC_DIFFERENCEThis function determines Determines the symmetric difference between two collections. It returns Returns a collection with the elements of the provided collections which are in either one of the collections, but not in both. Syntax
Inputs
Return type
Venn diagram Examples
|
bgColor | white |
---|
A note on collections and duplicates
An expression resulting in a collection does not contain duplicates. Please be aware however, that intermediary results of a COLLECT
statement can contain duplicates. You have to be aware of this when using the SIZE
or UNPACK
function, or when using TSL.
|
|
TSL:
The ages present are: [[[ COLLECT Person.Age FROM ALL Person ]]].
Now an example with the UNPACK function. We leave out the first instance from the previous example.
type | note |
---|
COLLECT
statement can contain duplicates. The functions UNIQUE
, UNION
, INTERSECTION
, DIFFERENCE
and SYMMETRIC_DIFFERENCE
always return collections without duplicates.
|
Overview
Content Tools