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:
