topic Joining Tables from multiple DB's in QlikView

Joining Tables from multiple DB's

Tue, 28 Mar 2017 20:13:30 GMT

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?

Re: Joining Tables from multiple DB's

marcus_sommer — Wed, 29 Mar 2017 13:21:24 GMT

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:

Incremental Load

Incremental Load Scenarios

- Marcus

Re: Joining Tables from multiple DB's

krishnacbe — Wed, 29 Mar 2017 13:26:32 GMT

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.