how to combine different table

Anonymous — Tue, 13 Nov 2012 07:49:09 GMT

Dear all,

I' ve to combine data from different tables in this way:

First table: masterdata

SupplieCode Name

123 AAA

456 BBB

Second tabel: purchase orders

SupplierCode OrderNr.

123 PO-111

456 PO-A1

Third Tabel: Purchase receivals

SupplierCode DocumentNr.

123 RC-222

789 RC-333

I've to provide a list of all suppliers starting from masterdata, with orders and receivals, but it's possible to have good receivals without orders or

purchase orders without receivals. For example, the supplier code 789, doesn't have any purchase order, but it's into a receival transaction, and I must

list him.

Is it possible ?

Thanks in advance for your help

Re: how to combine different table

Gysbert_Wassenaar — Tue, 13 Nov 2012 09:15:44 GMT

Use outer join. Like this:

Table:

load * Inline [

SupplierCode,Name

123,AAA

456,BBB

];

outer join load * Inline [

SupplierCode,OrderNr.

123,PO-111

456,PO-A1

];

outer join load * Inline [

SupplierCode, DocumentNr.

123,RC-222

789,RC-333

];

Re: how to combine different table

Anonymous — Tue, 13 Nov 2012 14:46:58 GMT

Thanks !!

topic Re: how to combine different table in QlikView

how to combine different table

Re: how to combine different table

Re: how to combine different table