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: 
micheledenardi
Specialist II
Specialist II

Left Join Issue

Good afternoon community,

probably i'm more newbie as I think because until today I thought to knew qlik Joins but now I'm here with a question for you.

Is there anyone can expain me why CASE1 result is different from CASE2 ?

It seems that doing the left join from SampleTable loaded with * qlik consider only SampleTable1 table and not the others.

I don't think is this because the second and third SampleTable table loaded with * goes on autoconcatenate on Main Table before applying the join statement  because on MainTable table all data of SampleTable2 and SampleTable3 are missing...


I'd attach the example data i've used...

Case.png

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

Accepted Solutions
sunny_talwar

The problem with the first case is that after the 1st left join, your MainTable have now a new field called Data. So now the join is not just on the Key field, but both Key and Data. And since the Key matches, but Data doesn't the join actually doesn't take place. You can check this by doing a Join instead of Left Join.

Case 2 works because, all the three excels are first concatenated before it gets left joined all at once.

Does that make sense?

View solution in original post

6 Replies
effinty2112
Master
Master

Hi Michele,

This is interesting. I don't think I can explain other than take from this that it's necessary to complete the join table before we attempt to use in a join. Thanks for posting this!

Regards

Andrew

sunny_talwar

The problem with the first case is that after the 1st left join, your MainTable have now a new field called Data. So now the join is not just on the Key field, but both Key and Data. And since the Key matches, but Data doesn't the join actually doesn't take place. You can check this by doing a Join instead of Left Join.

Case 2 works because, all the three excels are first concatenated before it gets left joined all at once.

Does that make sense?

micheledenardi
Specialist II
Specialist II
Author

Yes, your reasoning has lot of sense !

Thanks !

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

No problem at all

effinty2112
Master
Master

Lovely explanation!

sunny_talwar

Thanks Andrew