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:

      Capture1.JPGCapture2.JPGCapture3.JPG

      what Result I want to get is :

      Capture4.JPG

       

      however, actual situation is only first row:

      Capture5.JPG

       

      but when my sources change to:

      Capture1.JPGCapture6.JPGeverything goes well:

      Capture7.JPG

       

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