11 Replies Latest reply: Mar 9, 2018 4:03 AM by Sandra Pinto RSS

    Left Join

    Sandra Pinto

      Hi All

      I have 2 tables and I need to take some data from One table - Table A - to the other - Table B.

      Table A contains Employee ID's, Names and Types.

      Table B contains Employee ID's ,Labor Costs and Labor Hours.

      I would like to use table A to bring the Names and Types next to each Employee ID in Table B.

       

      Left join brings all the Employee ID's, so I am getting in Table B empty lines for Employee ID's which exist in Table A but donwt exists in Table B. How can I avoid these empty lines?

       

      In other words, I would like to use something similar to Vlookup in excel.

      I know I can use Mapping Load but this clause allows only one filed for each Mapping Load, right?

      Also, using Table A as a dimension is not useful to me because of other data in the script. That's why I need to bring the data into Table B rather than use a dimension to create the link between the two tables.

       

      Thank you,

      Sandra

       

      Table A:

      EmplyeeIDNameEmployeeType
      1AAAtype 1
      2BBBtype 1
      3CCCtype 1
      4GGGtype 1
      5HHHtype 1
      7KKKtype 2
      8WWWtype 2
      9XXXtype 2
      10YYYtype 2
      11MMMtype 2
      12NNNtype 2
      13DDDtype 2
      14EEEtype 2

       

      Table B:

      EmployeeIDPaidHoursLaborCost
      1221.159,335
      2197.8016,946
      3197.8018,231
      4197.8015,001
      533.412,529
      6195.5314,799
      7125.9011,205
      8228.3810,922
      9219.439,908
      10274.0318,449
      11200.808,837