Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
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

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

View solution in original post

2 Replies
Gysbert_Wassenaar

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
Anonymous
Not applicable
Author

Thanks !!