Discussion Board for collaboration related to QlikView App Development.
if i have 2 tables like the following:
How can i Lef Join() TABLE1 with TABLE2 if the first table is before the second in the script?
I can't change the order of the tables because i need to insert an expression in TABLE2 that involve also some fields of TABLE1.
Please, anyone have a suggest?
Basically bring TABLE1 again as a resident load below TABLE2 and then drop TABLE1 if necessary or to avid Synthethic keys.
Hope this helps
View solution in original post