How to add a Orphan Records check between 2 datasets

If you want to check if records exist in 1 dataset or table and do not exist in another dataset or table, you can use the Orphan Records or Orphan Keys rules in DvSum. Below are step by step instructions.

 

Step 1. Login to DvSum and navigate to Audit --> Manage Rules

SNAG-0047.jpg

 

Step 2. Click on Add Rule and Select Foundational Category and Orphan Records

SNAG-0048.jpg

 

Step 3: In the Rules Wizard, enter a description. Then fill in the Basic Input section with source , table and columns in the table you want to find orphan records in.

SNAG-0049.jpg

 

Step 4: Fill in the Reference input with source, table, columns that you want to check against. Note that if the column names are same between the 2, the system will automatically select those columns. You can ofcourse change themSNAG-0050.jpg

Step 5: Save the rule. The rule page will open up. Press Run to execute and test the rule

SNAG-0052.jpg

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk