You are viewing documentation for Data Trust v7.6 (latest).
Looking for the previous version? View v2024.06 documentation →

Data Trust › Scenario Studio › Scenario Builder

Condition Check Filter Enhancement in BDV

Use enhanced conditional expressions in BDV Condition Check rules.

Overview

The Condition Check Filter Enhancement in BDV allows users to define more complex conditional expressions for the Condition Check rule. Enhanced filters support multi-column expressions and logical operators for precise data quality validation.

Note: Ensure all required connection profiles are configured in the Administration module before building this scenario.

Prerequisites

• You are logged in to Data Trust with a Pro-User or Admin Pro-User role.
• A BDV scenario with a Condition Check rule has been configured.

Steps

Path: Data Trust › Scenario Studio › Scenario Builder › Condition Check Filter Enhancement in BDV

Figure 1: Bulk Data Validation

This step involves interacting with the Bulk Data Validation within the Condition Check Filter Enhancement in BDV workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 2: BDV Page

This step involves interacting with the BDV Page within the Condition Check Filter Enhancement in BDV workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 3: Connection Configuration

Select the appropriate connection from the dropdown to link this widget to its data source. Choosing the correct connection profile ensures the scenario reads from or writes to the intended database or file system.

Figure 4: Select database

The Navigator panel displays the available databases, schemas, and tables for the selected connection. Expand the tree to locate the required table or view, then click Select to add it to the widget configuration.

Figure 5: Metadata Added

Click Get Metadata to automatically retrieve the column structure and data types from the connected data source. Review the retrieved metadata and deselect any columns that are not relevant before proceeding to configure validation rules.

Figure 6: Select Required tables

This step involves selecting the Select Required tables within the Condition Check Filter Enhancement in BDV workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 7: Click on Condition Check button

Configure the Click on Condition Check button parameters including the target column(s), threshold values, and any custom expressions. After saving, the rule is added to the scenario and will be evaluated against every record when the scenario executes.

Figure 8: Condition check popup

The Condition check popup dialog exposes all available configuration options for this step. Review each field carefully and fill in the required values before clicking Save or OK to apply the configuration.

Figure 9: Apply Condition

Configure the Apply Condition parameters including the target column(s), threshold values, and any custom expressions. After saving, the rule is added to the scenario and will be evaluated against every record when the scenario executes.

Figure 10: Applied Condition

Configure the Applied Condition parameters including the target column(s), threshold values, and any custom expressions. After saving, the rule is added to the scenario and will be evaluated against every record when the scenario executes.