Youtube Linkedin Link Calendar-alt
Login/Register
Register Login

Cleansing Module Overview

Table of Content

MDP Resource Center
MDP Cleansing and Standardization

Video Guide

The Cleansing Module in Match Data Pro is designed to prepare your data for high-confidence matching by applying powerful cleansing, standardization, and normalization rules. This module ensures your data is clean, consistent, and ready for profiling, matching, exporting, or further processing.

Getting Started

To begin, add the Cleansing Module to your project. Click the Configure button to open the configuration panel.
You’ll see six cleansing categories, each with a variety of rule options. Most rules start by selecting a data source, followed by one or more columns. For multi-column rules, you can hold the Ctrl key to select several fields at once.

Creating and Running Rules

  • Once your cleansing rules are selected:
  • Click Save to add them to the Rule List (on the right).
  • Click Run Rules to begin cleansing the data.
  • While the rules are running, you can explore additional features from the menu, including:
  • Running rules directly
  • Viewing and editing your rule list
  • Saving your current rule set as a template
  • Deleting rules if needed

Saving and Loading Templates

  • To save your rule set:
  • Click Save Template, enter a name and description, and save.
  • To load a saved template:
  • Click Load Template
  • Select a template
  • Choose your new data source
  • MDP will attempt to auto-map columns using fuzzy logic
  • You can manually adjust mappings as needed
  • Click Load, and your rules will populate the Rule List

Editing Your Rule Set

  • Under Edit Rule Set, you can:
  • View all applied rules
  • Reorder them with drag-and-drop
  • Select individual or all rules for deletion or template saving
  • Pro Tip: This Save Template option lets you save only selected rules—ideal for modular rule creation.

Previewing Cleaned Data

  • After rules are finished running:
  • Click Preview Records to verify the results.
  • A new data source is created automatically, named after your original source with _cleansed appended.
  • This cleansed version is now ready for:
  • Matching
  • Profiling
  • Exporting
  • Additional cleansing workflows

Summary

The Cleansing Module is a powerful, flexible tool that simplifies your data preparation process. Whether you’re cleaning up messy imports, standardizing values, or applying normalization rules across datasets, Match Data Pro helps you do it all with speed and confidence.
Match Data Pro
An easier way to clean, match, and merge data.

FAQs

After logging in, navigate to your user profile settings where you can:

  • Change your password

  • Update your name and billing information

  • Add a phone number for multi-factor authentication

  • Set your default language

  • Configure your time zone, which is used across all timestamps in the tool

A free/test account allows you to process up to 1,000 records per project. To handle larger datasets, you’ll need to upgrade to a paid subscription.

Match Data Pro offers several UI customization options:

  • Adjust layout, menu style, text direction, and flow

  • Switch between light and dark modes

  • Change interface language

  • Toggle fullscreen mode

  • Receive and view notifications

You can enable notifications to alert you when processes begin or finish. Additionally, there’s a Live Chat feature at the bottom of the screen to connect with support anytime.

From the dashboard, click on the “New Project” button. You’ll be guided through the process of naming your project, selecting modules, and configuring settings.

Payments for subscriptions can be made via PayPal or Stripe (credit card).

You can reach out to the Match Data Pro support team through the Live Chat feature on the platform or by emailing support@matchdatapro.com.

Start Your First Project

To begin, click the New Project button from the dashboard.

Let's Start
Back to Home
Next: Profiling
Match Data Pro

At Match Data Pro, our core focus is fuzzy data matching and entity resolution but our platform goes far beyond that

Youtube Linkedin Link Calendar-alt
Quick Links
Contact Us

+1 (302)450-1978

sales@matchdatapro.com

Address: 1041 N Dupont Hwy #1713 Dover, DE 19901

Subscribe to Our Newsletter

Subscribe to our newsletter for the latest updates, insider news, special offers, and more regarding fuzzy data matching.

Copyright 2025 Match Data Pro. All Rights Reserved

Privacy Policy | Data Security and Certifications