How to get value from other excel source

[Anonymous]

I am new to talend. I have challenge that i have two input excel one has Employee details and other one has title info

Employee data.Employee Title

Output

Mobile or Contact number is common in both. I need to get the output as Employee data template with title filled using Employee Title sheet.

[Anonymous · Accepted solution]

Hi,

    This is a classic case where you need to use tMap component to join two tables using matching columns.

     I would recommend you to read the help document for tMap along with practicing sample scenarios. This will give you a grip on the concepts. I am sure you will be able to solve your query easily after that.

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/mxzKD~8eLuNFSXH6LMi7qg

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Hi Nikhil,
The suggestion helped me to find out solutions. Thank you very much.