4 Replies Latest reply: May 5, 2014 11:46 AM by Michel Drets RSS

    Fill empty values in table, based on another table

      Hello all,

       

      I have a table, in which certain values are missing. In this case, the Oracle Employee Numbers are missing.

       

      What I would like to do is fill these empty Oracle Employee ID values in my base table (which contains SAP Project and SAP_Employee). The Oracle Employee numbers are in another table and the link between the two tables is the field SAP employee.

       

      I've tried left/right/outer/inner joins etc - but feel like I'm missing something.

       

      More visually:

      file1.png

       

      The erroneous script I currently have is:

       

      BaseTable:
      LOAD Oracle_Project,
      SAP_Project,
      Oracle_Employee,
      SAP_Employee
      FROM
      [Base table.xlsx]
      (
      ooxml, embedded labels, table is Sheet1);

      outer Join (BaseTable)

      LOAD DISTINCT
      SAP_Project,
      SAP_Employee
      FROM
      [Naomi table.xlsx]
      (
      ooxml, embedded labels);



      /*join (BaseTable)
      Load
      SAP_Employee,
      Oracle_Employee
      FROM
      [EMployees.xlsx]
      (ooxml, embedded labels, table is Sheet1);

       

      But that leads to the following output, which is not what I'm looking for

      On the screenshot, you see that the first 4 rows did not receive an Oracle_Employe ID..

       

      file2.png

       

      Thanks for any help in this matter and regards,

       

       

      Michelle