Page Comparison

...

excluded(arrayA, arrayB)

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:

...