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
Rick+Spickelmier66071457
Posted: Thursday, June 26, 2008 5:28:25 PM
Groups: Member

Posts: 1
Hi!

I'm am working with the demo and have converted the IncrementalMatch example to Java. I have that working fine (minus the db files, just created in memory string array for testing). However, I want to be able to use the lookup tables for nickname processing (i.e., matching Beth to Liz to Elizabeth).

Do I have to do this manually? In other words, open up the DBF file and lookup first names based upon the nickname, substitute it in, and then do the match? Or is there a way for the matcher to internally do the lookups?


Nevermind.... figured it out :)
Tim61468773
Posted: Monday, June 30, 2008 8:20:29 AM
Groups: Administration

Posts: 16
RE: NickName lookup tables

Yes, you open up the distributed lookup table 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 MatchUp for Windows 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