Table of Contents
Understanding Validation Rules
Validation rules are important in making sure only the best data gets through. Validation rules determine what data you allow into the dataset.
What Are Validation Rules?
Quality Control: They check your data uploads to make sure they meet all the defined requirements.
Error Fixing: If there's something wrong, they'll let you know so you can fix it before submitting.
'True' or 'False'
Pass or Fail: When building and testing your rules, each rule gives a 'True' (all good!) or 'False' (needs work!) status.
Types of Validation Rules
Basic: When you add fields in Verodat, you define the format (like string, integer, etc.) and whether it's mandatory. The system automatically creates rules to check your data against these criteria.
Warning: If data gets a 'False', it'll be flagged, but you can still submit it. You can fix it if you want, and if not, it'll just be marked for review later.
Critical Error: If you get a 'False' here, you've got to fix the issue before submitting.
Adding Validation Rules to Your Data Store
Open the 'Rules' Window
Navigate to your Dataset, open it, click on "settings", then "Rules"
Create Your Rule
Click '+ Add Validation Rule'
Choose the target field and add a description
Set the Severity
Choose whether it's a 'Critical Error' (big red flag) or just a 'Warning' (yellow caution sign).
Critical Error - If the rule fails on a critical error then this will mark the data entry against the applied field in red. Data cannot be submitted until all critical errors are resolved.
Warning - If the rule fails on a warning then this will mark the data entry against the applied field in yellow. Warnings can be ignored and a valid mapped output will be created if only warnings exist in the validation file.
Build That Rule
Use the rule builder to "Build Expression" and craft your validation rule
Test your rule
Once you're happy with your rule, "Parse Expression" and then "Test Expression". Remember,
'True' = all good!,
'False' = needs work! (if you need help, reach out)
Save Your Work
Once you're happy with your rule, hit "Save".
Rinse and Repeat
Add as many rules as you need, and then you're ready for transformation rules.
With these steps, you'll ensure that only the best data makes it through to your dataset. It's all about keeping your data clean, clear, and ready to go. If you have any questions or need more help, just ask.