2 Replies Latest reply on Nov 14, 2018 12:15 AM by Ritesh Bisht

    Left join on duplicate excel sheet doesn't contain NULL values

    David Bentata

      Hi

      My data (Excel file) contain a list of Warehouses and Parts. W1 is the main warehouse.

        

      WarehousePart
      W1PART1
      W1PART2
      W1PART3
      W1PART4
      W1PART5
      W2PART1
      W2PART2
      W2PART3

       

      I want to determine which part in W1 exists in another warehouse

      and to reorder my data source to look like

         

      WarehousePartWarehousePart
      W1PART1W2PART1
      W1PART2W2PART2
      W1PART3W2PART3
      W1PART4nullnull
      W1PART5nullnull

       

      I dragged the same sheet twice and made Left Join by Part

      defined two filters

       

      1.

       

      2.

       

      The result is the same as Inner join

       

      Look like some NULL records are missing

          

      W1PART4nullnull
      W1PART5nullnull

       

      Any idea?