Comparison: In List

The In List comparison provides a way of making the application of a Match rule conditional on one or both identifier values (String, String Arrays) in a comparison being matched with a single value or list of values.

Use this comparison as a way to apply a Match rule only to a subset of the data in the Match process. For example:

Where a Match rule is designed to match Middle Eastern names, only apply it if a Country identifier matches a list of Middle Eastern countries.
Where a Match rule is designed to match Electronic products, only apply it if a Product Category identifier matches a single value.

The comparison may also be used to eliminate matches that would otherwise be caught by Match rules lower in the decision table, if used in a Match rule with a 'No Match' result; for example, so that matches on certain rules are only presented if Country or Nationality values are not in a list of safe values.

The following table describes the configuration options:

Option	Type	Description	Default Value
Require 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
Match whole value?	Yes/No	If Yes, the whole identifier value (or values) specified must match. If No, tokens within the identifier will be matched against the list. In this case, delimiters must be specified in the relevant fields below to determine how to split tokens.	No
Required value reference data	Reference Data	A Reference Data set with a list of values, for example a set of country codes.	Clear
Required value	Free text	A single value to match against. Note that if a Reference Data set and a value is specified, both are matched against.	Clear
Require match for all values?	Yes/No	If Yes, all tokens in the identifier value(s) must match against the required list or value.If No, any one of the tokens must match. This option is only used if Match whole value? is set to "No".	No
Delimiter characters reference data	Free text or browse	A Reference Data set with a list of delimiter characters used to tokenize identifier values before matching against the list. This option is only used if Match whole value? is set to "No".	None
Delimiter characters	Free text	This field is used to specify the delimiter characters to use as an alternative to linking to a Reference Data set. This option is only used if Match whole value? is set to "No". Note: Note: If a Reference Data list of delimiters and specific characters are entered here, both are considered delimiter characters.	None

Examples

This example uses the In List comparison to only apply a Match rule if both records being matched have a Country identifier value of "UK". The required options are set as follows (the other options are not used):

Table 1-42 Example 1 Options: In List

Option	Setting
Require data in both records?	Yes
Match whole value?	Yes
Required value	UK

Table 1-43 Example 1 Results: In List

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

This example uses the 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, match a list of country codes. For the purposes of the example, the list contains the values US and UK, but does not contain IR and DE.

The required options are set as follows (the other options are not used):

Table 1-44 Example 2 Options: In List

Option	Setting
Require data in both records?	No
Match whole value?	No
Required value reference data	Country List
Require match for all values?	Yes
Delimiter character	`,`

Table 1-45 Example 2 Results: In List

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