Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rittermd
Honored Contributor

Data Matching

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.

4 Replies

Re: Data Matching

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
Contributor III

Re: Data Matching

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
Honored Contributor

Re: Data Matching

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

rittermd
Honored Contributor

Re: Data Matching

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. 

Community Browser