Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bibopipo
Not applicable

how to combine different table

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: how to combine different table

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

];


talk is cheap, supply exceeds demand
2 Replies
Gysbert_Wassenaar
Not applicable

Re: how to combine different table

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

];


talk is cheap, supply exceeds demand
bibopipo
Not applicable

Re: how to combine different table

Thanks !!