1.3.3.8.7 Comparison: Equal or One/Both Fields Null (Solutions)
The Equal or one/both field null (Solutions) comparison determines if both attributes are equal, or either attribute is null.
Use the Equal or one/both field null (Solutions) comparison as a way to apply a Match rule only to a subset of the data when certain attributes are equal or data is missing.
The following table describes the configuration options:
| Option | Type | Description | Default Value |
|---|---|---|---|
|
Ignore case? |
Yes/No |
Sets whether or not to ignore case when comparing values. For example, if case is ignored, "Oracle Corporation" will match "ORACLE CORPORATION", which otherwise would not match. |
No |
Example
This example demonstrates the effect of using the Equal or one/both fields null (Solutions) comparison.
Example results:
Table 1-40 Example Results: Equal or One/Both Fields Null
| Value A | Value B | Comparison Result |
|---|---|---|
|
X |
X |
True |
|
X |
<null> |
True |
|
<null> |
X |
True |
|
<null> |
<null> |
True |
|
X |
Y |
False |