The Cleanse Settings page is a central hub for managing how data quality is measured and how field values are standardized. From here you can access configuration for Data Quality Models and Transform Rules.


Accessing Cleanse Settings

Navigate to Cleanse > Settings from the left sidebar.

Requirements:

  • An active DataGroomr license
  • Configure/Setup permission

If you do not have the required permissions, an Access Denied message will be displayed.


Settings Overview

The page presents three cards, each linking to a dedicated management area:


1. Data Quality Models

Build scoring rules to measure data quality across dimensions such as completeness, consistency, validity, and accuracy.

Data Quality (DQ) models let you define field-level scoring criteria and weight them to produce an overall quality score for each record. These scores are displayed on the Cleanse dashboard and can be used to prioritize cleanup efforts.


From this page you can:

  • Create new DQ models with custom scoring rules
  • Edit existing model configurations using the DQ Model Editor
  • Assign models to specific datasets
  • Clone or delete models

For detailed instructions, see: Manage Data Quality Models and Data Quality Model Editor.


2. Transform Rules

Standardize and normalize field values. Transform rules can be used to mass-transform data for standardized formatting or mass updates.


Transform rules define field-level operations such as changing text case, trimming whitespace, replacing values using dictionaries, or applying custom formulas. They can be applied manually via Mass Transform or automatically through scheduled triggers.


From this page you can:

  • Create new transform rules
  • Edit rule logic and field operations
  • Assign rules to specific datasets
  • Clone, copy between environments, or delete rules


For detailed instructions, see: Transform Rules and Mass Transform (Mass Update).


Related Articles