5 Replies Latest reply: Feb 13, 2018 10:50 AM by Frédéric MANET RSS

    Left Join does duplication

      Hi.

       

      As i know from sql when you use left join the script goes:

       

      table_A

      left Join table_B  on A.id = B.id

       

      in qlikview script i do like this:

       

      Table_A:

      ....

      Left Join (Table_A)

           load *

           resident Table_B

       

      "When i do that it duplicate rows, i guess it's because there is no expression of "on A.id = B.id

       

      ?how can i fix it