https://community.qlik.com/t5/App-Development/Resident-Load-from-multiple-tables/m-p/1622295#M46326 <P>Your Third statement is nonsense.</P><P>if you removed the third statement then statement 4 will throw a table not found error because&nbsp;statements 1 and 2 will result in one table with 30 rows. Qlik automatically treats tables with the same fields as a single table and will concatenate the results.</P> Tue, 10 Sep 2019 19:06:01 GMT chriscammers 2019-09-10T19:06:01Z https://community.qlik.com/t5/App-Development/Resident-Load-from-multiple-tables/m-p/1622293#M46325 <P>Suppose you have two tables. Table1 contains two field ID &amp; NAME and 10 rows, while Table2 contains the same fields and 20 rows. Now you enter this code in script editor:</P><P>Load * Table1</P><P>Load * Table2</P><P>Load * Table1 resident load table2</P><P>Drop Table2</P><P>How many rows will be there</P> Tue, 10 Sep 2019 18:57:26 GMT https://community.qlik.com/t5/App-Development/Resident-Load-from-multiple-tables/m-p/1622293#M46325 garima006 2019-09-10T18:57:26Z https://community.qlik.com/t5/App-Development/Resident-Load-from-multiple-tables/m-p/1622295#M46326 <P>Your Third statement is nonsense.</P><P>if you removed the third statement then statement 4 will throw a table not found error because&nbsp;statements 1 and 2 will result in one table with 30 rows. Qlik automatically treats tables with the same fields as a single table and will concatenate the results.</P> Tue, 10 Sep 2019 19:06:01 GMT https://community.qlik.com/t5/App-Development/Resident-Load-from-multiple-tables/m-p/1622295#M46326 chriscammers 2019-09-10T19:06:01Z