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