Fuzzy Data Matching

FuzzyMatch for Fuzzy Data Matching

An Overview of the 6 Easy Steps

A quick overview of the functionalities of FuzzyMatch

 

Advanced Matching Queries

A quick example of how to match on several fields at once or in sequence

 

Step 1: Import the datasets to match

Very easy. Use File/Open, then select the two datasets.

 

Step 2: Make a match query

Learn how to make powerful queries with minimum effort. Use our user-friendly boolean logic. Control the level of similarity, the number of fuzzy suggestions and which libraries you want to use.

 

Step 3: Identify duplicates

iugum Data Software identifies perfect duplicates in Table A to speed up the fuzzy data matching process. The summary of duplicates displays the duplicates in a structured manner. Very useful.

 

Step 4: Use the match board

With this convenient feature, you will never be in the dark. Just click on any cell to display a specific subset of your matches.

 

Step 5: Use the match toolbar

The match toolbar will be your best friend to review the matches after running your query. Use it to accept or reject suggested matches, add words or group of words to your libraries and much more.

 

Step 6: Produce a match report

Learn how to export the matches you have accepted. Select the fields you want to add to your report. Include duplicates or not.

Happy fuzzy data matching!

 

 

Sample Files

Use these sample files to get the most out of your free trial.

Match company names

Match people names

Learn More

Fuzzy Data Matching with iugum Data Software

Fuzzy Data Matching with iugum Data Software

You've carefully constructed your match criteria – Clean Perfect or Fuzzy Match types with appropriate sequence numbers for the match fields along with the libraries (Predefined, Synonym or Noise) that you want to use – and then hit the Match button to run the matching process.More »
iugum Data Match Board

iugum Data Match Board

Working in tandem with the Match View and the Match Toolbar, the Match Board displays a summary of the results of the matching process and controls what’s displayed in the Match View pane.More »
Multiple Match Queries

Multiple Match Queries

Sometimes data fields are stored individually but often used together. In the example in our Match Query tutorial, a person’s First Name and Surname are separate fields but we want to match on the complete name. To concatenate these fields into one piece of data to use in the match process, assign them both the same sequence number.More »
Efficient sequential matching with iugum Data Software

Efficient sequential matching with iugum Data Software

The rule-of-thumb here is to do the most exact matches first, the Clean Perfect ones, and then do the Fuzzy Matching. If there's more than one Clean Perfect match, first match on the field that most of the data records have.More »
More on the Usability of iDS - Part 2

More on the Usability of iDS - Part 2

Our last blog article looked at people's different styles of using software and introduced some ways in which iugum Data Software™ presents different usability options. We only got through three different scenarios before we ran out of room. So, in this post, we talk less about the different usability styles and more about hands-on tips for using iDS efficiently.More »
More on the Usability of iDS - Part 1

More on the Usability of iDS - Part 1

Has this ever happened to you? You have to work with a colleague at their computer, and they're in charge of the mouse and keyboard. And your hand is just itching and almost uncontrollably trembling to take over.More »
Making Smart Choices about the Libraries

Making Smart Choices about the Libraries

The increased flexibility in iDS v6 means that you don't always have to run the cleansing and matching power of iDS at full-speed -- you can dial it back a bit by choosing which libraries, if any, to use in the process. But with this new choice comes some responsibility, as you now have to really understand what the libraries are and how they work in order to make smart choices about which ones to use.More »
The Dashboard Panel

The Dashboard Panel

At the hub of the updates for iDS v6 is the new Dashboard panel, found along the bottom of the main screen. Used in conjunction with the Match panel, the options available through the Dashboard panel allow you to customize the flexibility of your data cleansing and data matches to an unprecedented selection of detail.More »
Beyond Perfect Matching with Clean Perfect

Beyond Perfect Matching with Clean Perfect

At its core, Clean Perfect performs an exact match, comparing two data items character by character; if they're exactly the same, then iDS returns a match. However, Clean Perfect does much more than this.More »
The Power of Sequencing

The Power of Sequencing

This post is about just two small fields on the Field Selection panel of iDS - "Match Type" and "Seq." And we give short shrift to Match Type, pointing you in the direction of previous blog posts for more details. So, what is it about the "Seq" field on the Field Selection screen that makes it worthy of an entire blog post (and more, if the truth be told)?More »