topic Re: How to Load and Resident from Two Tables in QlikView https://community.qlik.com/t5/QlikView/How-to-Load-and-Resident-from-Two-Tables/m-p/225392#M77710 <HTML><HEAD></HEAD><BODY><P>what does the Load(myfunction(name1,name2)) refer to?&nbsp; Is it pseudo code for any function?</P></BODY></HTML> Fri, 23 Sep 2016 16:25:57 GMT 2016-09-23T16:25:57Z How to Load and Resident from Two Tables https://community.qlik.com/t5/QlikView/How-to-Load-and-Resident-from-Two-Tables/m-p/225387#M77705 <HTML><HEAD></HEAD><BODY><P>How to load and resident from two tables like this.</P><P>LOAD $(myFunction(Name1, Name2))</P><P>RESIDENT Table1, Table2;</P><P>Name1 from Table1 and Name2 from Table2</P><P></P><P>Thanks &amp; Regards,</P><P>Eddy</P></BODY></HTML> Tue, 27 Apr 2010 11:35:51 GMT https://community.qlik.com/t5/QlikView/How-to-Load-and-Resident-from-Two-Tables/m-p/225387#M77705 2010-04-27T11:35:51Z How to Load and Resident from Two Tables https://community.qlik.com/t5/QlikView/How-to-Load-and-Resident-from-Two-Tables/m-p/225388#M77706 <HTML><HEAD></HEAD><BODY><P>You should load the data into a <B>temporary</B> table, resident load from it, then drop it:</P><P>TMP_TABLE:</P><P>LOAD Name1 FROM TABLE1;</P><P>JOIN (TMP_TABLE) LOAD Name2 FROM TABLE2;</P><P>Final_TABLE:</P><P>LOAD Name1,Name2 RESIDENT TMP_TABLE;</P><P></P><P>DROP TMP_TABLE;</P><P></P><P></P><P>Best regards,</P><P></P><P>Fernando D´Agosto <IMG alt="Travel" src="http://community.qlik.com/emoticons/emotion-58.gif" /></P><P></P></BODY></HTML> Tue, 27 Apr 2010 12:49:59 GMT https://community.qlik.com/t5/QlikView/How-to-Load-and-Resident-from-Two-Tables/m-p/225388#M77706 fernandotoledo 2010-04-27T12:49:59Z How to Load and Resident from Two Tables https://community.qlik.com/t5/QlikView/How-to-Load-and-Resident-from-Two-Tables/m-p/225389#M77707 <HTML><HEAD></HEAD><BODY><P>Or do it in place on your original table:</P><P style="padding-left:30px;">Table:<BR />LOAD Name1<BR />FROM Table1<BR />;<BR />JOIN Table<BR />LOAD Name2<BR />FROM Table2<BR />;<BR />LEFT JOIN Table<BR />LOAD $(myFunction(Name1,Name2))<BR />RESIDENT Table<BR />;<BR />DROP FIELDS Name1, Name2<BR />;</P></BODY></HTML> Wed, 28 Apr 2010 00:38:18 GMT https://community.qlik.com/t5/QlikView/How-to-Load-and-Resident-from-Two-Tables/m-p/225389#M77707 johnw 2010-04-28T00:38:18Z How to Load and Resident from Two Tables https://community.qlik.com/t5/QlikView/How-to-Load-and-Resident-from-Two-Tables/m-p/225390#M77708 <HTML><HEAD></HEAD><BODY><P>Perfect!<IMG alt="Beer" src="http://community.qlik.com/emoticons/emotion-22.gif" /></P></BODY></HTML> Wed, 28 Apr 2010 13:29:26 GMT https://community.qlik.com/t5/QlikView/How-to-Load-and-Resident-from-Two-Tables/m-p/225390#M77708 fernandotoledo 2010-04-28T13:29:26Z How to Load and Resident from Two Tables https://community.qlik.com/t5/QlikView/How-to-Load-and-Resident-from-Two-Tables/m-p/225391#M77709 <HTML><HEAD></HEAD><BODY><P>Thank you so much <IMG alt="Idea" src="http://community.qlik.com/emoticons/emotion-55.gif" /></P></BODY></HTML> Thu, 29 Apr 2010 02:41:50 GMT https://community.qlik.com/t5/QlikView/How-to-Load-and-Resident-from-Two-Tables/m-p/225391#M77709 2010-04-29T02:41:50Z Re: How to Load and Resident from Two Tables https://community.qlik.com/t5/QlikView/How-to-Load-and-Resident-from-Two-Tables/m-p/225392#M77710 <HTML><HEAD></HEAD><BODY><P>what does the Load(myfunction(name1,name2)) refer to?&nbsp; Is it pseudo code for any function?</P></BODY></HTML> Fri, 23 Sep 2016 16:25:57 GMT https://community.qlik.com/t5/QlikView/How-to-Load-and-Resident-from-Two-Tables/m-p/225392#M77710 2016-09-23T16:25:57Z