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

    Left Join does duplication



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



      left Join table_B  on A.id = B.id


      in qlikview script i do like this:




      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