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 Jonathan. This is what I have now in my current script, but I thought some Join Clause would be easier. That is to say, using 2 Apply Maps gets the work done, but is there another, simpler way?