...
Function: excluded()
Returns an Array of all items in one Array that are not contained within another Array.
Syntax
excluded(setAarrayA, setBarrayB)
| Argument | Type | Description |
|---|
| arrayA | Array | An Array of values of any type. |
| arrayB | Array | An Array of values of any type. |
Returns an Array of all items that are in setA arrayA that are not in setB arrayB.
Examples
excluded(
["a","b","c", "d","e"],
["a", "c","f","d" ]
)
Returns the Array ["b","e"], as do the three expressions below:
listToString(excluded(["a","b","c","d","e"],["a", "c","f","d"]))
listToString(excluded(["a","a","b","c","d","e"],["a", "c","f","d"]))
listToString(excluded(["a","b","c","d","e"],["a","a","c","f","d"]))If an excluded element appears more than once in the first array (array A), then it will appear the same number of times in the array returned:
excluded(["a","b","c","d","e","e"],["a","c","f","d"])returns
["b","e","e"].
To be clear, if an element in the first array (array A) exists at all in the comparator array (array B), then it will not count as excluded:
excluded(["a","b","c","d","e","e"],["a", "c","f","d","e"])returns
["b"]Note that if you want to construct conditional expression using excluded() as a predicate, you should use an intermediary countElements() function:
...