3 Replies Latest reply: Jan 5, 2017 5:12 PM by Sunny Talwar RSS

    Left Join Not Working (Except First Row)

      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:

      qlik.png

       

      Both Qvd's are attached.

       

      Thanks