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: 
natacalvi
Contributor
Contributor

How to load updated data from table 2 to table 1 without loading table 1?

Hello, I'm trying to do a left join by a call of a button (partial load), but the idea is that my table 1 is not reloaded, I would like to load the new data in table 1, using the data from table 2 without loading table 1, I'm loading table 2 normally, but the idea really is that table 1 does not suffer a new load. You can?

Labels (1)
1 Reply
Chanty4u
MVP
MVP

Try this 

Table1:

LOAD * FROM [lib://YourDataSource/Table1.qvd] (qvd);

 

Concatenate(Table1)

LOAD * FROM [lib://YourDataSource/Table2.qvd] (qvd)

WHERE NOT EXISTS(ID);