Verify your data
Create and edit rules that verify the accuracy and consistency of your data.
Create a reconciliation rule
The Rule Builder helps you create custom formulas using various sets, functions, and fields. You can use these rules to verify data accuracy. This process helps you catch errors early.
- Go to
- Go to Rules and click Create Rule.
- Enter the name and a description.
- In the Datasets section, select at least two and no more than four to compare.
- Select the data type for the sets and mark one of them as the primary data set.
- In the Rule Builder section, click the items from Fields and functions list to add them to the Condition field, or add the conditions manually.
- Optional: In the Identifier options section, you can select one or more identifiers for a given comparison Operator to help you create the condition for the rule.
- When you're done, click Run check to check your condition's syntax.
- Click Create to save the rule.
Create a rule set
Create a rule set when you often need to apply the same rules together.
-
You must create at least one rule before you can create a rule set.
- Go to
- Click Create Rule Set.
- Enter a name and a description for your rule set.
- Select the types for the number of data sets you'd like to compare.
- Click Check Available Rules to show a list of applicable rules you've created, based on the number of data sets you chose.
- In the Available rules section, select the rules you'd like to move to Selected rules.
- Click the arrows to move the rules from Available rules to Selected rules and vice versa.
- Click Create to save your new rule set.
Run a reconciliation
Learn how to run a reconciliation for one or more reconciliation rule sets.
-
You need at least one reconciliation rule set to run a reconciliation.