topic Re: How to get value from other excel source in Talend Studio

How to get value from other excel source

Anonymous — Fri, 24 May 2019 14:45:24 GMT

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.

Re: How to get value from other excel source

Anonymous — Fri, 24 May 2019 15:28:23 GMT

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 🙂

Re: How to get value from other excel source

Anonymous — Wed, 29 May 2019 02:41:38 GMT

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