I have three tables t1, t2 and t3 with keys k1, k1+k2 and k2 respectively. (Essentially, t2 connects t1 and t3) I need to filter the records from t2 which match the key values in t1 and then join the resultant to t3. Can any one suggest the proper join conditions?
If I use left join with t2 as the main table, I end up picking extra values from t1 and if I use t1 as the main table then there is no way for me to get data from t3.
Aah.. I was under the impression that I have to specify the table name when I join the two tables. but even without specifying table names, Qlik automatically identifies association based on column names.
Thank you Swuehl! Keep is a Keeper lol never understood the use of it till now.
I also found this helpful after reading your post.