Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Resident Load from multiple tables

Suppose you have two tables. Table1 contains two field ID & NAME and 10 rows, while Table2 contains the same fields and 20 rows. Now you enter this code in script editor:

Load * Table1

Load * Table2

Load * Table1 resident load table2

Drop Table2

How many rows will be there

1 Reply
Highlighted
Partner
Partner

Your Third statement is nonsense.

if you removed the third statement then statement 4 will throw a table not found error because 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.