Function: excluded()
Returns an Array of all items in one Array that are not contained within another Array.
Syntax
excluded(arrayA, arrayB)
| Argument | Type | Description |
|---|---|---|
| setA | Array | An Array of values of any type. |
| setB | Array | An Array of values of any type. |
Returns an Array of all items that are in setA that are not in setB.
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"]))
Note that if you want to construct conditional expression using excluded() as a predicate, you should use an intermediary countElements() function:
//a list of managers known to us $validManagersList = ["Rob","Bob"], //a list that will only have a member if the manager on the output record //is not found in the list of known managers $exclusions = excluded(_out.Manager, $validManagersList), if(countElements($exclusions) > 0, addElement($errorArray, "The manager on this record was not found in the list of known managers")),
This will add to a list of errors if there is (at least) one member in the list of exclusions.