Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »



Function: excluded()

Returns an Array of all items in one Array that are not contained within another Array.

Syntax

excluded(arrayA, arrayB)

ArgumentTypeDescription
setAArrayAn Array of values of any type.
setBArrayAn 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.

See Also

  • No labels