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

       

      Vendor

      =====

      ABC LTD

      ABC LIMITED

      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?