...
Returns an Array of all items that are in arrayA that are not in 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:
...