Comparison: ALL in List

The ALL in List comparison determines if all the values contained within the attributes are present in a list.

Use the All in List comparison as a way to apply a Match rule only to a subset of the data by checking for records that only contain particular values from a list.

This comparison does not support the use of result bands.

The following table describes the configuration options:

Option	Type	Description	Default Value
Delimiter	Free text	This field is used to specify the delimiter characters to use.
List	Reference Data	A Reference Data set with a list of values, for example a set of country codes.	Clear
Match requires data in both records	Yes/No	If Yes, both input identifier values must contain data. If they do not, the comparison will always be 'False'. If No, only one input identifier value must contain data.	No

Option

Type

Description

Default Value

Delimiter

Free text

This field is used to specify the delimiter characters to use.

List

Reference Data

A Reference Data set with a list of values, for example a set of country codes.

Clear

Match requires data in both records

Yes/No

If Yes, both input identifier values must contain data. If they do not, the comparison will always be 'False'.

If No, only one input identifier value must contain data.

Example

This example uses the All in List comparison to only apply a Match rule if all country codes in a comma-separated list of country code tokens, on both records being compared, are contained within a list of country codes. For the purposes of the example, the list contains the values US and UK, but does not contain DE.

Table 1-32 Example Options: ALL in List

Option	Setting
Delimiter	`,`
List	Country List
Match requires data in both records	Yes

Example results:

Table 1-33 Example Results: ALL in List

Value A	Value B	Comparison Result
UK	US	True
UK,DE	US	False
UK,US	no data	False
UK	UK	True