Left Join Not Working (Except First Row)

[#1]

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 · Accepted solution]

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

Left join broken in QlikView 12 SR1?

[andreas_koehler]

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]

I am glad this was helpful.

Happy New Year my friend