Page History
Panel | |||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||
UNIQUEThe Syntax
Input
Return type
Examples Suppose the following model.
|
Panel | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||
SUBSET OFThis function returns Syntax
Inputs
Return type
Venn diagram Examples
|
Panel | |||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||
UNIONAdds two collections of the same base type to a new collection. Syntax
Inputs
Return type
Venn diagram Examples Suppose you have a
|
Panel | |||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||
INTERSECTIONThis function determines the intersection of two collections. It returns a collection containing the items that are present in both specified collections. Syntax
Inputs
Return type
Venn diagram Examples Suppose the following model. Entity
|
Panel | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||
DIFFERENCEThis function returns a collection containing all the items from collection1 that are not present in collection2. Syntax
Inputs
Return type
Venn diagram Examples
|
Panel | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||
SYMMETRIC_DIFFERENCEThis function determines the symmetric difference between two collections. It 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
|
Panel | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
A note on collections and duplicatesAn expression resulting in a collection does not contain duplicates. Please be aware however, that intermediary results of a This is best illustrated with the following examples.
Now an example with the UNPACK function. We leave out the first instance from the previous example.
|