Invert Rule Test
The
CompareToConstant,
CompareToField, and
MatchesRegex rules display the
Invert Test parameter which allows to report the opposite results in the pass or fail file. This option is also available when you add these rules (see
Add New Rule).
To invert a rule test:
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. Select the rule for which to edit the Invert Test parameter.
The Rule Definition pane on the right, displays the rule details.
3. In the Parameters section, select Invert Test.
Select this option if you want to report the opposite results in your pass or fail file.
For example, the 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.
4. Save the profile.
Last modified date: 04/17/2026