Fuzzy/Close Name Match

[Anonymous]

Hi,

I am not able to get to a very important concept of fuzzy/close match in QV. Not sure if it has the capability of that.

As an example here is what I am looking to do. I have 2 name fields in 2 different files. Employee Name in Employee file and Vendor Name in Vendor file. I need to run a search to see if any of the employees are acting as vendors, this can't be done using exact join as there could be a small variation in the name, usually a letter or two.

Like matching Lynne to Lynn, John Smithe to Jon Smith.

Please advise

Thanks

Sunny

[MarcoWedel]

Hi,

check the "omit rows where field is null" option on the presentation tab for fields that are null in non matching cases:

hope this helps

regards

Marco

[Anonymous]

Thanks a lot Marco

[MarcoWedel]

you're welcome

glad it helped

regards

Marco

[Anonymous]

Hi Marco,

is it possible to create this in Qlik Sense e.g. using Sub / Call?

Regards,

Muliady