https://community.qlik.com/t5/QlikView/How-to-Left-Join-a-table-with-another-below/m-p/1650235#M593571 <P>TABLE1:</P><P>...</P><P>TABLE2:</P><P>...</P><P>left join</P><P>Load</P><P>...</P><P>Resident TABLE1;</P><P>Basically bring TABLE1 again as a resident load below TABLE2 and then drop TABLE1 if necessary or to avid Synthethic keys.</P><P>Hope this helps</P> Fri, 22 Nov 2019 16:21:07 GMT bharathadde 2019-11-22T16:21:07Z https://community.qlik.com/t5/QlikView/How-to-Left-Join-a-table-with-another-below/m-p/1650231#M593570 <P>Hi,</P><P>if i have 2 tables like the following:</P><P>TABLE1:</P><P>...</P><P>TABLE2:</P><P>...</P><P>How can i Lef Join() TABLE1 with TABLE2 if the first table is before the second in the script?</P><P>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.</P><P>Please, anyone have a suggest?</P><P>Thanks,</P><P>Mattia</P> Fri, 22 Nov 2019 16:14:50 GMT https://community.qlik.com/t5/QlikView/How-to-Left-Join-a-table-with-another-below/m-p/1650231#M593570 Mattia 2019-11-22T16:14:50Z https://community.qlik.com/t5/QlikView/How-to-Left-Join-a-table-with-another-below/m-p/1650235#M593571 <P>TABLE1:</P><P>...</P><P>TABLE2:</P><P>...</P><P>left join</P><P>Load</P><P>...</P><P>Resident TABLE1;</P><P>Basically bring TABLE1 again as a resident load below TABLE2 and then drop TABLE1 if necessary or to avid Synthethic keys.</P><P>Hope this helps</P> Fri, 22 Nov 2019 16:21:07 GMT https://community.qlik.com/t5/QlikView/How-to-Left-Join-a-table-with-another-below/m-p/1650235#M593571 bharathadde 2019-11-22T16:21:07Z