Was this helpful?
Add Rules from Derived Fields
You can add rules for a derived field in the same way as you add rules for a source field. See Add New Rule.
To add a new rule using derived fields:
1. Open an existing profile and select the Rules tab.
2. Click and select Add a New Rule from the context menu.
The Add Rules dialog is displayed. This dialog allows you to add rules for a single derived field. To add rules to multiple derived fields, launch the dialog multiple times. The rule parameters can be configured once back in the editor.
3. Select a derived field from the Select Field Name drop-down list.
The derived fields are listed at the bottom of the drop-down list and their names are preceded with a “d_” unless you changed the default name. Based on the selected derived field, the available rules get listed in the Profiling, Remediation, and Data Prep tabs.
4. Select a rule and click Finish.
The Add Rules dialog (for details see Add New Rule) closes and focus returns back to the Rules tab, and the new rule is displayed on the Field/Rule pane. The rule details are displayed on the Rule Definition pane. A default rule name is provided which follows the <FieldName>_<RuleType> format. For example, City_IsNotBlank. You can edit the name or click Reset to revert to the default name.
Note:  The underscore (_) character is the only special character allowed in the name. Rule names cannot begin with a digit. If a field or column in the source data starts with a digit, 'r_' will be prepended to any rules created based on that field.
5. Specify the rule parameters (see Rule and Parameter Reference).
Note:  The parameters may be different for different Rules.
6. Save the profile.
 
Last modified date: 01/08/2026