MatchUp Object:Swap Matching Uses

From Melissa Data Wiki
Jump to navigation Jump to search

← MatchUp Object Reference

MatchUp Object Matchcodes Navigation
Matchcodes
Component Properties
Component Combinations
Blank Field Matching
Matchcode Mapping
Optimizing Matchcodes
Swap Matching Uses



Swap matching is used to catch matches when two fields are flipped around. The most common occasion is catching the “John Smith” and “Smith John” records. But there are other uses:

Comparing Household Records

When there are two or three first or full names per record, a list provider may claim that every record is always “husband, wife, then children,” but records can then read "wife, child, then husband."

Component Size Fuzzy Swap 1 2 3 4 5 6
Zip5 5 Exact None X X X X X X
Last Name 5 Exact None X X X X X X
First Name 5 Exact A/B X X
First Name 5 Exact A/C X X
First Name 5 Exact B/C X X
PO Box 10 Exact None X X X
Street Number 5 Exact None X X X
Street Name 4 Exact None X X X

In the above example, select Either component can match for Swap Pairs A, B, and C.

Comparing up to Three Address Lines

Although the address splitter works well in the US and Canada, some European countries can cause problems. A typical Euro-Matchcode will not use street split components and look at three address lines instead. The swap matching ensures that every address line is compared with every other address line.

Component Size Fuzzy Swap 1 2 3
Zip9 10 Exact None X X X
Last Name 5 Exact None X X X
First Name 5 Exact None X X X
Address 10 Exact A/B X
Address 10 Exact A/C X
Address 10 Exact B/C X

Again, select Either component can match for Swap Pairs A, B, and C.

Don’t always discard the street split component matchcodes because you are working with a foreign database. Sometimes the street splitter will yield usable results. Therefore, a combination of approaches will often work.

Component Size Fuzzy Swap 1 2 3 4 5
Zip9 10 Exact None X X X X X
Last Name 5 Exact None X X X X X
First Name 5 Exact None X X X X X
PO Box 10 Exact None X
Street Number 5 Exact None X
Street Name 4 Exact None X
Address 10 Exact A/B X
Address 10 Exact A/C X
General 10 Exact B/C X