BusinessObjects Board

Check for Transposed Names not letters?

dataservices data quality
#1

Is there a technique anyone can provide with regards to putting names in to order before doing a match? For example

First Name = John
Middle Name = Daniel
Last Name = Smith

First Name = Smith
Middle Name = John
Last Name = Daniel

Many Thanks for any input you can think of.

Thanks

Toby

phatz (BOB member since 2009-04-21)

#2

The data cleanse has a name order setting for names that come in first/last, last/first or unknown.

the results are often questionable, but if its free form data and you really dont know which order theyre coming in… it should help.

jlynn73 :us: (BOB member since 2009-10-27)

#3

You need a really good test for “bad” first names, and if you find one, you arbitrarily swap them… I’d think the only way to do this would be a table of names that you would want to switch, “SMITH” in your example below - if you find a first name in this table, you would switch.

The problem is names like mine, where your first and name is equally likely to be reversed (I get Doug a lot instead of Brent)… I’d lean toward letting names go thru rather than reversing them, so my check table would tend towards small.

Good luck!
B

bdouglas :switzerland: (BOB member since 2002-08-29)