Matching partial data between tables

Tue, 08 May 2012 12:17:42 GMT

Hi All

I'm trying to join two tables where I have a requirement to join using more than just the one common field.

Given the following two example tables:

keytable:

LOAD * INLINE [

hostname, key

batman, abc

robin, abb

orca, abd

elephant, abe

];

moredata:

LOAD * INLINE [

hostname, data

batman, 123def8

robin, /poi/abb89

orca, 898:abdxxx

giraffe, poid09a

];

What I need to do is look for the value in key in the keytable table in the data column in moredata.

So given the above examples I would create a link between robin in both tables and orca in both.

Any ideas? What I sort of need to do is like a substringcount check between fields in different tables for

all possible values in keytable against moredata.

Many Thanks
Harry

topic Matching partial data between tables in QlikView