Identity Director Administration Guide

Home 

Function: @[DIFFERENCE]

The function @[DIFFERENCE(<set1>,<set2>,(<separator>))] returns the values that are present in dataset 1 and not in dataset 2. The <separator> argument is optional.

Example:
@[DIFFERENCE(A;C;E,B;C;D;E)] returns A.

  • Arguments set1 and set2 can also be defined as attributes, placeholders or functions.
    Example:
    @[DIFFERENCE(#Global[Att1.EntireColumn.Name],#Service[Att2.EntireColumn.Name])]

    Column names that are used in this function cannot contain parentheses (()) or square brackets ([]).

  • If a separator is not specified, the default separator is a semi-colon (;).

    The comma (,) cannot be used as a separator in the datasets, because it is used as the separator between the function arguments.

If you insert the @DIFFERENCE function from the Create pattern window, the <separator> argument is wrapped in additional parentheses (()) to indicate that it is optional:
@[DIFFERENCE(<set1>,<set2>,(<separator>))]
You must remove these parentheses to use the argument.
Example:
@[DIFFERENCE(A|C|E,B|C|D|E,|)]

See also

Was this article useful?