5 Replies Latest reply: Jul 12, 2017 10:52 PM by tang ling RSS

    Miss left join duplicated rows

    tang ling

      Hi Friends,


      I am in a trouble in left join function.

      my two sources and code as below pictures:


      what Result I want to get is :



      however, actual situation is only first row:



      but when my sources change to:

      Capture1.JPGCapture6.JPGeverything goes well:



      but in actual situation, I don't have AB2 in second table, what I can do to get the result I need?