1.3.2.2 Cross-attribute Check

The Cross-attribute Check processor allows you to compare the values in two attributes in order to check the consistent application of a business rule.

Note that you can only compare attributes of the same Data Type; that is, a String attribute must be compared with another String attribute, a DATE with another DATE, and a Number with another Number.

Use Cross-attribute Check to check that the data for two related attributes is correct. For example, you may want to check that Date_Of_Death values are later dates than Date_Of_Birth values.

The following table describes the configuration options:

Configuration	Description
Inputs	Specify two attributes that you want to compare. The attributes must be of the same data type.
Options	Specify the following options: Comparison Operator: drives how to compare the two attributes. Specified as a selection (Is less than, Is less than or equal to, Is equal to, Is not equal to, Is greater than, Is greater than or equal to, Starts with, Ends with). The Starts with and Ends with options may only be used when comparing two String attributes. Default value: Is equal to. Ignore case?: determines whether or not case differences should be ignored when comparing attribute values, for example, whether or not 'LONDON' is considered as the same as 'London.' Possible values: Yes/No. Default value: Yes.
Outputs	Describes any data attribute or flag attribute outputs.
Data Attributes	None.
Flags	The following flag is output: CrossAttributeCheck: indicates which records pass the Cross Attribute Check. A value of '-' means that the outcome was unknown, meaning that one of the attributes contained a Null value. Possible values are Y, N, or -.

The following table describes the statistics produced by the profiler:

Statistic	Description
Records passing comparison	The number of records that passed the comparison.
Records failing comparison	The number of records that failed the comparison.
Records with null value(s)	The number of records where either, or both, values being compared were null.

Output Filters

The following output filters are available from a Cross-attribute Check:

• Pass; that is, records where the comparison passed

• Fail; that is, records where the comparison failed

• Null comparison; that is, records with a null value in either or both attributes checked

Example

In this example, two attributes are compared: DT_ACC_OPEN and DT_PURCHASED, to see how many have repeated data:

Records Passing Comparison	Records Failing Comparison	Records with Null Value(s)
996	3	1

You can drill down on the Records Passing Comparison:

DT_ACC_OPEN	DT_PURCHASED	CrossAttributeCheck
03/01/2000	03/01/2000	Y
06/01/2000	06/01/2000	Y
10/01/2000	10/01/2000	Y
14/01/2000	14/01/2000	Y