Doing multiple Left joins in qlikview

[#1]

Hi,

I want to do multiple left joins in qlikview script

For example:

In SQL:

((select * from TabA A

left join

select * from TabB B) on A.id=B.id) NewTab N

left join TabC c on C.id=N.ID;

Like this I have to do series of left joins with qvds

Thanks,

Akanksha

[sunny_talwar]

Should be just like this....

QUALIFY *;

UNQUALIFY id, ID;

Table:

LOAD *

FROM A.qvd;

Left Join (Table)

LOAD *

FROM B.qvd;

Left Join (Table)

LOAD *,

     ID as id

FROM B.qvd;

UNQUALIFY *;

[#3]

Thanks for explaining this:

Table:

LOAD *

FROM A.qvd;

Left Join (Table)

LOAD *

FROM B.qvd;

Left Join (Table) << here I want to join with A& B combined result set with New table. Will Table contain both A&B data? reason Im asking is Table label loads only A.qvd. Pls correct if Im wrong

LOAD *,

     ID as id

FROM B.qvd << Do u mean here C.qvd?

[sunny_talwar]

Yes I meant C.qvd..... sorry about that....

So this how the above will happen

Table get created from A.qvd

Table:

LOAD *

FROM A.qvd;

Join more columns where id's match between A.qvd and b.qvd (call this a new table with columns from A.qvd and B.qvd)

Left Join (Table)

LOAD *

FROM B.qvd;

Join more where ID matchs id

Left Join (Table)

LOAD *,

     ID as id

FROM C.qvd;