Intersect Function
Description:
Those members of the first list which are also members of the second list.
note
Note that duplicates are removed from the intersection.
Returns:
Any*
Parameters:
Parameter | Data Type | Description |
|---|---|---|
1 | Any* | The first list. |
2 | Any* | The second list. |
Examples:
When using functions inside a field, remember the field brackets:
{Intersect(MemberList, StaffList)}
Expression | Result |
|---|---|
Intersect( List("a","b","c"), List("b","c","d") ) | List("b","c") |
Intersect( List("a","a","b","b","c"), List("b","b","c","c","d") ) | List("b","c") |