Inspecting Data and Auto Adding Rules using Wizard
When Creating a Profile Using Data Profile Wizard, you can click 
(Inspect Data and Auto Add Rules) on the Create Data Quality Rules page, to use internal algorithms which inspect the source data and recommend rules based on knowledge of the source schema and various data pattern matching tests. This method is recommended if you are not sure about the data problems of your source data.
(Inspect Data and Auto Add Rules) on the Create Data Quality Rules page, to use internal algorithms which inspect the source data and recommend rules based on knowledge of the source schema and various data pattern matching tests. This method is recommended if you are not sure about the data problems of your source data.To auto inspect data and add identified rules:
1. On the Create Data Quality Rules page, click 
.
.The system uses internal algorithms which inspect the data and add rules based on knowledge of the source schema and various data pattern matching tests. Under the Create Rules section the auto generated rules are listed by field in alphabetical order, with the field metrics sorted by percentage failed.
2. Review the auto generated rules.
You can choose to keep all the auto generated rules or select a rule and click 
to delete it.
to delete it.Note:
- The New Data Profile Wizard provides only a subset of rules that can be used to discover the quality of your source data. Use the Data Profile Editor to explore the full set of rules that you can use. For a complete list of available rules, see Rule and Parameter Reference.
- Inspect Data and Auto Add Rules can only be run once. If you want to run it again, you must first delete any rules that were auto added from the first run.
- If you have an existing rule (one of the four listed commonly used rules) for a rule that was returned by the inspection, the existing rule is kept and the recommended rule is ignored. Any missing field is added to the existing rule.
- The New Data Profile Wizard provides only a subset of rules that can be used to discover the quality of your source data. Use the Data Profile Editor to explore the full set of rules that you can use. For a complete list of available rules, see Rule and Parameter Reference.
- Inspect Data and Auto Add Rules can only be run once. If you want to run it again, you must first delete any rules that were auto added from the first run.
- If you have an existing rule (one of the four listed commonly used rules) for a rule that was returned by the inspection, the existing rule is kept and the recommended rule is ignored. Any missing field is added to the existing rule.
Last modified date: 12/03/2024