topic AW:Let join between two tables in QlikView

Let join between two tables

Anonymous — Sat, 16 Apr 2011 11:14:06 GMT

Hi,

I have two tables.The structure as follows:

TAB1:

LOAD * INLINE

[OrderNo

3];

TAB2:

LOAD * Inline

[OrderNo,PId,Qty

1,0,12

2,0,13

];

My question is how to make a third table (Tab3) after making left join between these two tables.

The output of the Tab3 table will be:

OrderNo PId Qty

1 0,12

2 0,13

3 -,-

plz help me.

I have tried an application,attached for your review.

ashfaq_haseeb — Sat, 16 Apr 2011 11:25:14 GMT

Find the attached file.

Hope that helps

Regards

ASHFAQ

Sat, 16 Apr 2011 12:58:12 GMT

Hello chadan,

take a look at my suggestion:

Regards, Roland