With the help of this enhancement in DvSum application, Blank values will be write back-able to the Source data. Let's get started with following steps to be able to understand how this works.
There are two checks that user needs to make sure are applied.
- Rule Level
- Table level
Note: Please note that this configuration will be applicable to all rules except BLANKS RULE.
Rule Level Check
Step 1 : Value Range Rule
Lets consider an example of VR rule in which first the rule definition will be checked for blanks and then table level configurations will be checked. For the rest of rules, only table level configurations will be checked to allow blanks.
Go to Manage Rules tab, search for any VR rule, click the rule to open the rule detail page. Once the rule detail page is displayed, click on the Definition tab. Now click the Edit button. Right under Specify Range value section, you will see the "Include Blanks" check box. Check this box and also make sure that "Valid" option is selected for values. Hit the save button as shown below;
Note: If "Include Blanks" is not checked and "Valid" option is selected above, still it won't allow to write back for blank values.
Step 2 : Now click Analysis tab and see on which table the exceptions are showing up as shown below;
Table Level Check
Step 3 : Go to Profiling section, select source, table name and click the Select button. Once the record is displayed, select it and click Show details option as shown below;
Step 4 : Once the details page is displayed, select Field Configuration tab. In this tab, "Allow Blanks" column is added. Now, search for the table name and verify Allow blanks option is checked for instance; in this case it was COUNTRY, re-run the rule as shown below;
Step 5 : Once the rule is re-run, go back to rule detail page and click Cleanse button. On Cleanse detail page, note the Remaining Exception count shown above, click on Edit option for any field, remove the value, leave it blank and apply the change as shown below;
Step 6 : As soon as you apply the change, observe that it allows the blank value and Remaining Exception count also gets reduced. Save it and Commit the change. as shown below;
Step 7 : After change is committed, the field color turns Green which confirms that the write back was successful as shown below;
Scenario 1 : When Rule level check is enabled but Table level check is disabled, in this case the Blank won't be write back-able and user will be notified at Cleanse detail page as shown below;
Scenario 2 : When Table level check is enabled but Rule level check is disabled, in this case the Blank won't be write back-able and user will be notified at Cleanse detail page as shown below;