MatchUp Object:Swap Matching Uses
| MatchUp Object Matchcodes Navigation | |||||||
|---|---|---|---|---|---|---|---|
|
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 |