topic Re: Left Join Not Working (Except First Row) in QlikView

Left Join Not Working (Except First Row)

Tue, 26 Apr 2016 14:39:15 GMT

Hi Community,

I'm having this issue with a left join: It only works with the first row of my Fact table.

FACT1:
LOAD fact_yymm, 
     fact_code
FROM [FACT_TABLE.QVD] (qvd);

LEFT JOIN (FACT1) 
LOAD fact_yymm,
     fact_ddmmyy
FROM [DATE_TABLE.QVD] (qvd);

My result:

Both Qvd's are attached.

Thanks

sunny_talwar — Tue, 26 Apr 2016 16:39:45 GMT

You must be using QV12 SR1. This is a known issue and should be resolved in QV12 SR 2

andreas_koehler — Thu, 05 Jan 2017 16:51:07 GMT

Thanks Sunny,

for pointing into the right direction.

This issue nearly drove me mad.

Seems that the automatic update of my stand-alone client wasnt working. I was still at QV12 SR1.

How can such a basic function be bugged.

Happy New Year!

sunny_talwar — Thu, 05 Jan 2017 22:12:15 GMT

I am glad this was helpful.

Happy New Year my friend