Fuzzy Lookup in Table/minichart

[#1]

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?

[amien]

Unfortionatly Qlikview doesn't have any fuzzy matching functions like n-gram, liechtenstein etc..

What i did : create VBA functions and use those functions in your load script. You can find plenty of VBA examples on the net. It's really slowing down the loading, so perhaps you have another software option to do the matching for you.

[#3]

Hi,

Thanks for the reply, Can you provide me a sample QVW with your example please?  What I am struggling to understand is how I refer to the whole dataset within the dataset field.

I.e.

[Table1].[SpecificColumnValue] = [Table1].[AllValuesOfThat Column]

Thanks.

[amien]

This is a good start with Fuzzy Matching Function.

For Looking though a whole data set .. check out Rob's CookBook for wildmatch : http://robwunderlich.com/downloads/