>I tried to several keyword searches, but I cannot find what I am looking for. I am looking for an algorithm to match peoples' identities that are being reported from different sources. We will have: first name, last name, address, city, state, zip, a birthdate, a gender, and an ID. The information is being reported from numerous retail outlets. So there are variations on how the information will be reported. Elements such as names could be spelled differently. And some items may be erroneous or missing in specific instances. The ID may be that of the customer or that of the person picking up for the customer. ID consists of a government issued ID such as social security number, drivers license ID, passport number - so even if it is the same person in different records, the ID reported may be different.
>
>TIA,
>Mariam
Did you try DIFFERENCE() and SOUNDEX()?
Or you could start educating your sources. :)
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
