topic Fuzzy Match or Similar? in QlikView

Fuzzy Match or Similar?

dmac1971 — Wed, 27 May 2015 08:08:11 GMT

Lets say I have 2 cols, I want to see if any word in col2 appear in col1? If a word matches in both then flag it etc.

Re: Fuzzy Match or Similar?

Siva_Sankar — Wed, 27 May 2015 08:16:26 GMT

Find the attached application and let me know whether this is what you want.

Re: Fuzzy Match or Similar?

dmac1971 — Wed, 27 May 2015 08:21:26 GMT

Not really I'm afraid. Both cols contain a number of words within a text string, if it was single chars or single words in both that would be fairly easy to do. Thanks though!

Re: Fuzzy Match or Similar?

pokassov — Wed, 27 May 2015 08:30:20 GMT

Hello!

//--- original table

t1:

LOAD * Inline [

id, t1, t2

1, John Hello, Max Bye John

2, Frank, Piter

];

//--- separate first col by words

t2:

LOAD

id,

SubField(t1,' ') as s1

Resident t1;

//--- separate second col by words

t3:

LOAD

id,

SubField(t2,' ') as s2

Resident t1;

//--- find out the same words

Inner Join (t2)

load

id, s2 as s1

Resident t3;

DROP Table t3;

//--- if col1 and col2 have more then 1 same word - leave only one id per row

t3:

LOAD

Distinct id,

1 as flag

Resident t2;

DROP table t2;

//--- add flag to original table

Left Join (t1)

LOAD

id, flag

Resident t3;

DROP Table t3;

Re: Fuzzy Match or Similar?

dmac1971 — Wed, 27 May 2015 13:59:43 GMT

Used the Subfield method and then marked each record as Y/N match. Thanks.!