Discussion Board for collaboration on QlikView Scripting.
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:
LOAD * INLINE [
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.