Data Quality Tools, Mailing Software, Lists, NCOA, Data Enhancements

 | Shopping Cart Buy | Newsletters | Search

    Products         Solutions       Downloads & Trials       Support          Resources         Lookups       Contact Us  

Logged in as: Guest Search | Active Topics |

Lookup Tables Options · View
Tim61468773
Posted: Monday, June 30, 2008 8:29:16 AM
Groups: Administration

Posts: 16
Comments, questions of usage, and any recommendations for additions are all welcomed here!
Tim61468773
Posted: Monday, June 30, 2008 8:36:35 AM
Groups: Administration

Posts: 16
NickName Lookup Table Usage

You open up the distributed lookup table (Tools | Lookup Tables - from the menu bar on the main screen) and edit, delete or add entries which you want to be found as matching names. Ex: 'Chuck' and 'Charles' are both entered as CHAS, and therefore the matchkey gets built with CHAS instead of the original name.

MatchUp automatically checks this lookup table only when your matchcode uses a First/NickName component (instead of or also with a FirstName component).

CAUTION: Don't overuse or edit this table. At first glance, it may seem like a good idea to add 'John' and 'Jack' as a nickname match. But you may end up matching: Jonathon > Jon > John > Jack > Jackson, then Jonathon would match Jackson. HEAVILY TEST any changes you make to this table before implementing in your processing environment.

NOTE: This logic applys to the MatchUp API as well.
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by Yet Another Forum.net