I would like to implement a DQ accuracy rule where Attribute A is accurate if and only if its value is greater than Attribute B. Attribute B cannot be derived from Attribute A.
For example:
Attribute A: Date of Death
Attribute B: Date of Birth
Rule: Date of death needs to be greater than date of birth for a particular person.
Best answer by Katerina
Hi Kdrose,
This can be implemented by comparing the two attributes directly in the rule logic.
For your example:
Rule Logic: Date_of_Death is not null AND Date_of_Death <= Date_of_Birth
In this example, a null Date of Death is considered valid, as the person may still be alive. The rule only verifies that when a Date of Death is provided, it is later than the Date of Birth.
Attribute B does not need to be derived from Attribute A. Both attributes can be mapped as inputs to the rule, and the rule evaluates their values for the same record.
Regards,
Katia
+1Hi Kdrose,
This can be implemented by comparing the two attributes directly in the rule logic.
For your example:
Rule Logic: Date_of_Death is not null AND Date_of_Death <= Date_of_Birth
In this example, a null Date of Death is considered valid, as the person may still be alive. The rule only verifies that when a Date of Death is provided, it is later than the Date of Birth.
Attribute B does not need to be derived from Attribute A. Both attributes can be mapped as inputs to the rule, and the rule evaluates their values for the same record.
Regards,
Katia
And in ONE Agentic there is an option to choose to which attribute report the result (Doc: Score only the attributes a rule targets)
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
