logical comparision of customer name/address in AuditStage
Posted: Fri Jan 18, 2008 7:02 am
After conversion, we want to compare customer names.
Customer names have been deduplicated enriched, updated, currently a lot of customers use the same customer number name, address description, where we used a number of descriptions in the past, a lot of these descriptions look alike, but are not equal. Is there a String Similarity function available we are looking for a way to logically compare the content of a alpha field (range between 80-100% match)
e.g.
Medical systems COMPARING to Philips Medical Systems
Hendrikx COMPARING TO Hendriks
Is there a routine available to deliver a Data Matching percentage on Product and/or Customer names. What we want is a relialibility % of account names/address/City/product names after conversion and deduplication.
Did try
select SOUNDEX(PRIVATE_LABEL), SOUNDEX(REMIT_TO_NAME), DIFFERENCE(PRIVATE_LABEL,REMIT_TO_NAME)
FROM AUTOBILLEG
Do urgently need a better alternative
Regards and thank you for your help
Customer names have been deduplicated enriched, updated, currently a lot of customers use the same customer number name, address description, where we used a number of descriptions in the past, a lot of these descriptions look alike, but are not equal. Is there a String Similarity function available we are looking for a way to logically compare the content of a alpha field (range between 80-100% match)
e.g.
Medical systems COMPARING to Philips Medical Systems
Hendrikx COMPARING TO Hendriks
Is there a routine available to deliver a Data Matching percentage on Product and/or Customer names. What we want is a relialibility % of account names/address/City/product names after conversion and deduplication.
Did try
select SOUNDEX(PRIVATE_LABEL), SOUNDEX(REMIT_TO_NAME), DIFFERENCE(PRIVATE_LABEL,REMIT_TO_NAME)
FROM AUTOBILLEG
Do urgently need a better alternative
Regards and thank you for your help