topic Re: Left Join Issue in QlikView

Left Join Issue

micheledenardi — Thu, 13 Jul 2017 14:53:30 GMT

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...

Re: Left Join Issue

effinty2112 — Thu, 13 Jul 2017 15:08:55 GMT

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

Re: Left Join Issue

sunny_talwar — Thu, 13 Jul 2017 15:14:36 GMT

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?

Re: Left Join Issue

micheledenardi — Thu, 13 Jul 2017 15:19:20 GMT

Yes, your reasoning has lot of sense !

Thanks !

Re: Left Join Issue

sunny_talwar — Thu, 13 Jul 2017 15:20:46 GMT

No problem at all

Re: Left Join Issue

effinty2112 — Thu, 13 Jul 2017 15:26:14 GMT

Lovely explanation!

Re: Left Join Issue

sunny_talwar — Thu, 13 Jul 2017 15:28:33 GMT

Thanks Andrew