3 Replies Latest reply: Feb 17, 2016 1:47 PM by Jessica Tung RSS

    JOIN on null value

    Jessica Tung

      Hi I have a script like below,  how do I get to the expected result? Tried join but didn't work. Thank you!

       

      A:

      LOAD * INLINE [

          A, B, C

          1, 2

          11,22,33

      ];

       

       

      join

      LOAD * INLINE [

          A, B, C, D

          1, 2, 3, 4

      ];


      Result:

      ABCD
      12
      1234
      112233


      Expected:

      ABCD
      1234
      112233