Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try this
Table1:
LOAD * FROM [lib://YourDataSource/Table1.qvd] (qvd);
Concatenate(Table1)
LOAD * FROM [lib://YourDataSource/Table2.qvd] (qvd)
WHERE NOT EXISTS(ID);