Data Matching

[rittermd]

I have a situation where I have 2 excel files that I need to associate.

Unfortunately the only common field between the 2 is the persons name.  Most of the names match between the 2 files.  However, I have situation where the person is a Jr. or Sr. and this only appears in one of the files.

Is there a way that I can strip out the components of the name fields and then compare the parts that I know match?

Or is there a fuzzy match function?

I realize that even this could have issues.  But it is all that I have to work with. I just need to get as close as I can with what I have to work with.

[its_anandrjs]

You can remove Jr Or Sr from all tables and then match or may be Mapping the Jr or Sr where it is not available then make it standard.

Can you share some sample.

[markp201]

Check subfield.  This will let you break up a field into pieces.  Assuming the max parts - prefix, first, middle, last, suffix you can use space as the delimiter.  You can also use substringcount to see how many pieces you have

https://community.qlikview.com/thread/63516

[rittermd]

Thank you.  I will give this a try tonight and get back to you.

[rittermd]

Subfield actually would not work.  Or at least I could not get it to work. 

I ended up using a nested Replace on the name field for Jr., Sr. III, etc and that worked perfectly.