Rules play a crucial role in shaping and transforming data into a format ready for reporting. Let's break down the concept of rules for a better understanding.
Table of Contents
What are Rules in Verodat?
The Verodat rules engine is a powerful tool that applies data governance and business rules to prepare and transform data seamlessly.
Verodat's flexible rule engine can be configured to support various business data rules.
It uses special tools in a formula setup, using math-like expressions and a type of logic (Boolean logic) to make rules work.
Boolean logic is a type of logic that deals with binary conditions, where an outcome can be either true (1) or false (0). Boolean logic is fundamental to computer science and programming, where it is used to make decisions based on conditions. It involves operations like AND, OR, and NOT to manipulate and analyze true/false values. In simple terms, it's a way of representing and solving problems using binary choices.
Types of Rules and Their Functions
Filter Rule:
Eliminates unnecessary rows from data submissions before upload.
Mapping Rule:
Matches fields of a data upload to the target state in a Verodat dataset.
Supports complex mappings, mathematical expressions, and concatenation options.
Validation Rule:
Governs and cleanses submitted data by checking uploads against requirements.
Prompts data suppliers to resolve errors before submission.
Transformation Rule:
Converts data fields from one format to another.
Consumes input data or available enrichment data to create a new data point.
Customized Rules:
The Verodat rules engine is highly flexible, with few limitations. Complex additional functional rules can be provided by the Verodat technical support team via the helpdesk.
Where can Rules be Triggered?
Rules can be triggered from or include data from various sources, such as:
a field
a row
a data file
other datasets, or
other reference sources
Rule Examples
Lookup Rules:
Checking fields against a defined reference table list (e.g., currency, country code, ZIP code).
Conditional Rules:
Specifying an allowed range for values (e.g., date range, price range, time range).
Chronological/Combinational Rules:
Creating a required combination or sequence that data must follow.
Computational Rules:
Mathematical expressions (e.g., sum of orders must equal total order amount).
Transformation Rules:
Formulae to convert the format of data from one state to another.
In Summary
Rules in Verodat are a set of guidelines that govern various aspects of data preparation, ensuring a streamlined and efficient process. From filtering unnecessary rows to transforming data formats, Verodat's rules engine empowers users to wield data effectively, regardless of complexity.
If you encounter challenges or need custom rules, our technical support team is ready to assist via the helpdesk.