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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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);