Skip to main content
Solved

Match on US Name Synonyms

  • September 17, 2024
  • 1 reply
  • 27 views
F
Universe Traveller
  • fshahinUniverse Traveller
  • Universe Traveller
  • 11 replies

Hi All,

How can I use the file us_ca_firstname_synonym.lkp to create a match? Like Robert Smith should match with Bob Smith. I checked the file and for one name it has multiple synonyms. I can fetch the result in clean component but not sure how do I use that in Match component to generate match. Your help is much appreciated. Thanks in advance.

Thanks

FS

Best answer by Ales

Hi @fshahin ,

the file us_ca_firstname_synonym.lkp is a lookup file specifically generated for a Name standardization component. Of course you can use it for any other use case you might want however you might need to generate a specific .lkp file which would fit your purpose.

 

If you are ok with the structure of us_ca_firstname_synonym.lkp as it is, you use the lkp in the matching following these steps:

  1. matching plan - prepare a MAT_FIRST_NAME_SYNONYMS value which based on the .lkp file would contain ALL the synonyms + the original name. Use a reasonable separator between values
  2. pass this value to the matching
  3. create a Key Rule Name in the matching step by using this MAT value similarly as depicted below (just a non working example)
  4. this will allow the engine to match records based on ALL synonyms in the field / the “behave as set” option enabled is important.
  5. adjust your Matching rules as you need
View original
Did this topic help you find an answer to your question?

1 reply

Ales
Ataccamer
Forum|alt.badge.img+2
  • AlesAtaccamer
  • Ataccamer
  • 27 replies
  • Answer
  • October 11, 2024

Hi @fshahin ,

the file us_ca_firstname_synonym.lkp is a lookup file specifically generated for a Name standardization component. Of course you can use it for any other use case you might want however you might need to generate a specific .lkp file which would fit your purpose.

 

If you are ok with the structure of us_ca_firstname_synonym.lkp as it is, you use the lkp in the matching following these steps:

  1. matching plan - prepare a MAT_FIRST_NAME_SYNONYMS value which based on the .lkp file would contain ALL the synonyms + the original name. Use a reasonable separator between values
  2. pass this value to the matching
  3. create a Key Rule Name in the matching step by using this MAT value similarly as depicted below (just a non working example)
  4. this will allow the engine to match records based on ALL synonyms in the field / the “behave as set” option enabled is important.
  5. adjust your Matching rules as you need
Ales
Cansu
1 person likes this
  • Cansu
    Cansu

Reply


Most Liked this week

Community Terms of Use & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings