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.
Note: The Data Profiler .dp artifact is not supported in DataConnect 12.5 and therefore cannot be opened for editing. It has been replaced by a .dq (Data Quality) file and a .dq.rtc (Runtime Config) file. Please recreate the profile as .dq and .dq.rtc artifacts. You can right-click on the .dp file to view profile content in a JSON editor. Also note that some rules have been deprecated or replaced with new rules. For more information, see Deprecated Rules.
2. Click 
and select Add a New Rule from the context menu.
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: 04/17/2026