Environment Details
======================
EDQ Version: 12.1.3.0.0
I am using a Business rules processor to implement multiple business rules on a single record and I am looking to get a summary of the number of records that passed and failed a given rule.
To illustrate:
Suppose there are 2 rules, Valid number on Column1 and Valid number on Column2.
There are 10 records to be processed and 3 records fail rule 1(Valid number on Column1) and 9 records fail rule 2(Valid number on Column2).
In the Result Browser of the Business Processor, the number of records that passed and failed is shown but its not part of the output of the processor itself. In the above example there will be 1 pass and 9 fail records and given the said values the total record count can be derived which is 10.
Hence the expected output will be:
Pass Fail
Rule 1: 7 (10-3) 3
Rule 2: 1 (10-1) 9
Note: The number of records which failed can be derived from the array of rule ID but I don't know how to get the total record count in order to derive the number of records that passed a given rule.
I tried to publish the Pass and Fail count in the Result Browser of the Business Processor in a staging table and refer to the same staging table to get the pass and fail values but EDQ does not allow writing and reading the same staging object in a single process. What is the best way of getting the total record count processed by the Business Rules Processor? Can these kind of attributes (that are available only in Result Browser) be included in the output of the processor in the next EDQ release?
Also, the staging table only contains 1 record with pass and fail values while the exceptions which have individual failure on each rule contains 12 records. What would be the best approach to merge a single record into multiple records as per the below example?
Staging Table
Pass Fail
1 9
Exception Table
Rule ID Unique ID
Rule 1 Record1
Rule 1 Record2
Rule 1 Record3
Rule 2 Record1
Exception Table with Merged data from Staging Table
Rule ID Unique ID Pass Fail Total
Rule 1 Record1 1 9 10
Rule 1 Record2 1 9 10
Rule 1 Record3 1 9 10
Rule 2 Record1 1 9 10
Please advise.