Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can you join tables from multiple DB's and inner join.
For example, I know that you can do the following:
//connection 1
final:
Load *
;
Sql select table 1
from db1
//connection 1
inner join(final)
Load *
;
Sql select table 2
from db2
However, in doing this you must first load the entire table 1 and table 2 into Qlikview. The tables i'm dealing with are very large(47 million rows) and I would like to do the inner join immediately without pulling in the entire table. Is this possible?
If one of the databases could connect to the other and pulling the data from there by simultaneous joining them with the own data - then it might be possible to trigger this task through qlik and to receive those data. But I assume it won't be possible. Maybe you could instead apply an incremental approach, like:
- Marcus
My Suggestion would be create two QVDs from two DB tables and perform the join in QVD files.
And as suggested by Marcus you can implement Incremental Loan in QVD layer.