Joining tables

jduenyas — Mon, 05 Aug 2013 22:31:44 GMT

Hi all

I have query (a complex query), call it query "X", in SQL server wich I load into TableA. (The load takes failrly long)

I then load from another query, call it query "Y", that contains query "X" and additional tables into TableB.

(This query takes much longer because it contains query "X" as one of the components.)

I think I can speed up the load by simplifying query "Y" by omitting query "X" and make the join in the load using Resident TableA since it is already loaded.

I do need though some fields from TableA and additionals from query "Y" to create TableB.

I am stuck with how to join the tables.

Here is the scenario:

Qualify *;

Unqualify a;

TableA:

LOAD a, b, c, d

FROM query X;

TableB:

LOAD a, b, c, x, y, z

FROM query Y LEFT JOIN

query X on Y.a = X.a;

Is it possible to change the LEFT JOIN portion and instead use Resident TableA instead, keeping in mind that I need to bring fields b and c from TableA into TableB?

Thanks for your input.

Re: Joining tables

tresB — Tue, 06 Aug 2013 04:31:53 GMT

try something like this:

Qualify *;

Unqualify a;

TableA:

LOAD a, b, c, d

FROM query X;

TableTemp:

Load a,b,c Resident TableA;

Right Join (TableTemp) // qlikview joins on common field (here,'a'), so don't have to mention it explicitly

TableB:

LOAD a, x, y, z

FROM query Y

Drop Table TableTemp;

topic Joining tables in QlikView

Joining tables

Re: Joining tables