topic Re: Fuzzy Search in Scripts in QlikView

Fuzzy Search in Scripts

Roop — Thu, 06 Dec 2012 14:44:07 GMT

I am looking to define a true fuzzy search in scripting form so that it would find the most likely result from an input:

Input:

Blk

Black

White

Blu

Lookup Table:

Black

White

Blue

Pink

Orange

Result:

Input	Result
Blk	Black
Black	Black
Bk	Black
White	White
Blu	Blue
B	Blue or Black
Pk	Pink

as can be seen, this example cannot use wildcards, but must use fuzzy logic. Under ideal circumstances, there would be a factor that would say how close the match was - I know this bit is asking a lot!

I have thousands of records that I wish to match in this way .........

Thanks in advance.

Re: Fuzzy Search in Scripts

richardpayne — Thu, 28 Mar 2013 13:24:48 GMT

Just giving this thread a bump. I'm interested in this solution as well.

Re: Fuzzy Search in Scripts

VishalWaghole — Sat, 30 Mar 2013 09:40:45 GMT

PFA of qvw application file that will help you.

Thanks

Vishal

Re: Fuzzy Search in Scripts

Mon, 01 Apr 2013 08:03:28 GMT

Hello Rupe,

Try following below steps:

1) LOAD the below script.

2) Create a Straight table, with Color and Fuzzy as dimensions.

3) use below expression

=WildMatch(Color,mid(Fuzzy,1,1)&'*'& mid(Fuzzy,2,1)&'*' & mid(Fuzzy,3,1)&'*')

Script

Input:

LOAD * INLINE [

Fuzzy

Blk

Black

White

Blu

];

LookupTable:

LOAD * INLINE [

Color

Black

White

Blue

Pink

Orange

];

Please let me know if this was helpful or anything else is required.

Thanks,

angad

Re: Fuzzy Search in Scripts

Roop — Wed, 03 Apr 2013 12:10:41 GMT

Sorry - have been away for a while. Yes a useful response but I specifically wanted to use fuzy logic as opposed to semi-fuzzy logic - if that makes sense .....