Managing Rules
You can add and manage rules on the Profile tab. Once executed, these rules will help identify anomalies and issues within specific data patterns, formats, and values. For more information about profiler rules, see Rule and Parameter Reference.
The rules toolbar at the top-right of the profile tab, provides a means of managing rules and accessing the AutoGen wizard and the Inspecting Data and Auto Adding Rules functionality.
Tip... Hover over each toolbar item to view its description.
The following table provides information about the various toolbar icons:
Icon | Description |
|---|---|
 | Displays information about the number of rules that have been defined. |
 | Clears or deletes all the rules from the Rule grid. See Clear Rules. |
 | Disables selected rules. See Disable and Enable Rules. |
 | Enables selected rules. See Disable and Enable Rules. |
 | Deletes selected rules. See Delete Rule. |
 | Edits selected rule. See Edit Rule. |
 | Adds a new rule. See Add Rule. |
 | Invokes the AutoGen wizard. See Generating Rules using AutoGen Wizard. |
Add Rule
To add a new rule:
1. Open an existing profile and select the Profile tab.
2. Click 
or right-click the Rules grid and select Add a new Rule.
or right-click the Rules grid and select Add a new Rule.The New Rule window is displayed.
3. Select a rule from the Metric Type dropdown list. For more information about rules, see Rule and Parameter Reference.
Note: Metric Type list is filtered to show only those types for which there are fields with supported datatypes.
4. Select a field from the Field Name dropdown list.
Note: Derived fields are listed below all the source fields.
In the Rule Name field, a default rule name is provided. However, you can edit the name or click Reset to revert to the default name.
5. In the Parameters section, select the Invert Test option if you want report the opposite results in your pass or fail file.
Note: This parameter is displayed only for Compare to Constant, Compare to Field, and Matches Regex Rule.
Note: Other parameters may also be displayed based on the other Metric Types that you select. For more information about rule parameters, see Rule and Parameter Reference.
6. Click Finish.
The New Rule window is closed and the new rule is displayed on the Rules grid.
Tip... .Right-click the Rules grid and select the Undo or Redo option to undo or redo all rule operations.
Edit Rule
To edit a rule:
1. Open an existing profile and select the Profile tab.
2. On the Rules grid, select the rule that you want to edit.
3. Click 
or right-click the row and select Edit Selected Rule.
or right-click the row and select Edit Selected Rule.The Edit Rule window is displayed.
Tip... You can also double-click a rule row to edit the rule.
4. Edit the Metric Type, Field Name, Rule Name, and Parameters information as per requirement.
For more information, see Add Rule and Rule and Parameter Reference.
5. Click Finish.
The Edit Rule window is closed and the updated rule information is saved.
Invert Rule Test
To invert a rule test:
1. Open an existing profile and select the Profile tab.
2. On the Rules grid, select the rule for which to edit the Invert Test parameter.
3. Click 
or right-click the row and select Edit Selected Rule.
or right-click the row and select Edit Selected Rule.The Edit Rule window is displayed.
Tip... You can also double-click a rule row to edit the rule.
4. In the Parameters section, select Invert Test.
Select this option if you want to report the opposite results in your pass or fail file. Compare To Constant rule that uses an equal Operator will pass a record and put it in the PASS_TARGET file if the field value is equal to the specified Constant value. Inverting this test will put that same record in the FAIL_TARGET file.
Note: The Invert Test parameter is displayed only for Compare to Constant, Compare to Field, and Matches Regex Rule. This option is also available on the New Rule window when you Add Rule.
5. Click Finish.
The Edit Rule window is closed and the updated rule information is saved.
Delete Rule
To delete Rule:
1. Open an existing profile and select the Profile tab.
2. On the Rules grid, select the rule that you want to delete.
3. Click 
or right-click the row and select Delete Selected Rules.
or right-click the row and select Delete Selected Rules.A Delete Confirmation message is displayed.
4. Click OK.
The selected rule is deleted.
Tip... .Right-click the Rules grid and select the Undo or Redo option to undo or redo a delete operation.
Disable and Enable Rules
You can choose to run a profile, with only specific rules enabled, to speed up the execution time. Thus by disabling not required rules you can concentrate on a specific rule based testing, and resetting before moving on to another field rule.
To disable a rule:
1. Open an existing profile and select the Profile tab.
2. On the Rules grid, select the rule that you want to disable.
3. Click 
or right-click the row and select Disable Selected Rules.
or right-click the row and select Disable Selected Rules.The selected rule text looks disabled (is grayed out) and the icon changes to 
.
. Note: This option is enabled only when a rule is enabled.
To enable a rule:
1. Open an existing profile and select the Profile tab.
2. On the Rule grid, select the rule that you want to enable.
3. Click 
or right-click the row and select Enable Selected Rules.
or right-click the row and select Enable Selected Rules.The selected rule text is enabled and the icon changes to 
.
.Note: This option is enabled only when a rule is disabled.
Clear Rules
To clear all rules:
1. Open an existing profile and select the Profile tab.
2. On the Rule grid, select the rule that you want to clear.
3. Click 
or right-click the row and select Clear All Rules.
or right-click the row and select Clear All Rules.All the rules in the Rule grid are deleted.
Tip... Right-click the Rules grid and select the Undo or Redo option to undo or redo a delete operation.
Last modified date: 07/26/2024