3 Replies Latest reply: Mar 6, 2012 6:04 AM by Amien Amien RSS

    Fuzzy Lookup in Table/minichart

      Hi Guys/Gals!


      I am trying to work something out which I am sure QlikView can do but not sure how to start..


      We have a table with a column called "Vendor" this should be a unique name but we are getting duplicates as the user is entering the vendor slightly differently.


      Basic example




      ABC LTD


      XYZ Corporation

      XYZ Corp



      So in this case ABC LTD and ABC LIMITED are the same vendor.


      In SSIS you can perform a fuzzy lookup and provides a probability of the duplication.  Is there a specific function in QV that can do the same thing?


      I imagine it will be with functions like match/mixmatch/wildmatch but not sure how to reference the dataset again within an expression.  Any ideas people?