The Match Against Trusted Source option allows records from one dataset to be matched exclusively against a designated Master Table, rather than performing a full comparison across all datasets involved in the project.


When this option is enabled, WinPure will prompt you to select which dataset should act as the Master Table. The Master Table typically represents a trusted, authoritative source of data—for example a validated customer database, reference list, or previously deduplicated dataset.


Once selected, WinPure performs the matching process as follows:

  • Records from the secondary dataset(s) are compared only against the Master Table.
  • Records within the secondary dataset are not matched against each other.
  • The Master Table remains the reference dataset used to identify matches.

This approach is particularly useful when you are importing new or external data—such as enrichment files, newly acquired contact lists, or recently collected records—and you want to determine whether those records already exist within your trusted dataset.


Internal Integrity Check


To help maintain data integrity, WinPure also performs a quick internal scan of the Master Table for exact matches.

If any high-confidence duplicates are detected within the Master Table itself, these are automatically flagged and displayed on the All Matches tab for review. This ensures that even trusted datasets can still be checked for potential duplicates without performing a full re-matching operation.


When to Use This Option


The Match Against Trusted Source mode is best suited for scenarios such as:

  • Validating new records against an existing master database
  • Checking external enrichment files against internal systems
  • Identifying existing customers, suppliers, or contacts in a trusted dataset
  • Preventing unnecessary matching across datasets that should not be deduplicated together


Benefits


Using the Match Against Trusted Source option provides several advantages:

  • Faster processing by avoiding unnecessary dataset-to-dataset comparisons
  • Controlled matching logic where one dataset acts as the authoritative reference
  • Improved data governance by protecting the integrity of trusted master data
  • Clear identification of relevant matches when onboarding new or external data sources

By focusing the matching process on a designated trusted dataset, users can streamline data validation workflows while maintaining confidence in the quality and reliability of their master data.