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

Missing records using Outer Join

Hi,

I have met some issues with Outer Join.

While working on small tables, it does work properly. However, when I tried joining 2 big tables with 4 data fields in common, there are some missing keys and records.

Given an example below, the record boxed in red (while joining 2 tables with many columns) went missing. Any idea what's wrong?

Picture2.png

Kindly advise if you have met such problem before. Thanks in advance!

7 Replies
micheledenardi
Specialist II
Specialist II

There is nothing wrong on the Output table.. Outer join it's working properly....

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
micheledenardi
Specialist II
Specialist II

Which is your expected result ?

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

Hi Michele,

That's right. But currently, the last row was missing.

Based on my observation, it seems to be working like a left join E.g. Left Join (Table 1) instead of outer join even though I explicitly mentioned it.. Could it be because there are too many columns in Table 1 (about 20+ fields)?

micheledenardi
Specialist II
Specialist II

Can you share your code ?

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

gg 678 hh  this combination may not be avialable in table1 or format or datatype may be changed for field1 field2 field3

Anonymous
Not applicable
Author

Hi Kulwant,

Thank you for your response.

Are you referring to original Table 1 or output table, which is also called Table 1? Since I have used

Outer Join (Table 1)

GG-678-HH record is residing in Table 2 when table is loaded. (checked)

However, when I tried to do an outer join on Table 1 and Table 2, it did not appear in the combined table.

Only records highlighted in yellow, and records from Table 1 are found, which is how it is supposed to be.

But records unique to Table 2 are not showing up.

Anonymous
Not applicable
Author

Hi

Using your data its not missing records

Table1:

load F1&F2&F3 as key ,F4,F5;

LOAD * INLINE [

    F1, F2, F3, F4, F5

    aa, 123, dd, 1234567, abcd

    bb, 234, ee, 2234567, efgh

    cc, 345, ee, 3345678, jklm

];

outer join(Table1)

Table2:

Load F1&F2&F3 as key,F6;

LOAD * INLINE [

    F1, F2, F3, F6

    aa, 123, dd, 111

    gg, 678, hh, 222

];

output:

Capture.PNG