topic Fuzzy Lookup in Table/minichart in QlikView

Fuzzy Lookup in Table/minichart

Fri, 02 Mar 2012 15:56:48 GMT

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?

Fuzzy Lookup in Table/minichart

amien — Fri, 02 Mar 2012 16:01:36 GMT

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.

Fuzzy Lookup in Table/minichart

Mon, 05 Mar 2012 08:17:27 GMT

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.

Re: Fuzzy Lookup in Table/minichart

amien — Tue, 06 Mar 2012 11:04:57 GMT

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/