Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
garima006
Partner - Contributor
Partner - Contributor

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
chriscammers
Partner Ambassador
Partner Ambassador

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.