Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thanks a lot Marco
you're welcome
glad it helped
regards
Marco
Hi Marco,
is it possible to create this in Qlik Sense e.g. using Sub / Call?
Regards,
Muliady