10 Replies Latest reply: Jun 5, 2012 12:23 PM by John Witherspoon RSS

    Left Join not working as expected.

      Here is the script :

       

      A:

      Load * Inline

      [id, Category

      0,cat0

      1,cat1

      2,cat2];

       

      B:

      Load * Inline

      [id, SubCategory

      0,subCat0

      1,subCat1

      3,subCat3];

       

      Left Join(A)

      Load *

      Resident B;

       

      idCategorySubCategory
      0cat0subCat0
      1cat1subCat1
      2cat2
      3
      subCat3

       

      Was not expecting the row corresponding to id=3 here.

       

      while :

       

      Roght Join(A)

      Load *

      Resident B;

       

      idCategorySubCategory
      0cat0subCat0
      1cat1subCat1
      3
      subCat3

       

      Could some one help me with it ?