I'm trying to take data from 2 different excel sources(Different formats) and want to create a sheet that adds specific information to another formatted sheet that I need to create. I was researching some of the custom components but couldn't figure out which one to use.
Could you please elaborate your case with an example with input and expected output values?
Welcome to Talend Community and Happy New Year!!!
Well just as @xdshi, you can give a in-detail description about your scenario which would help others who are referring to the topic and it would yield them a better understanding.
Also, till where i understood you would like to take data from 2 different source and of different formats and then create a formatted sheet with the information what you have gathered from the those sources???
Pls correct me,if i have misunderstood something!!.
2 different sources and of different format excel and taking data from them can be done... but why have 2 sheets meaning why one sheet for storing the output and why dumping and transforming the data in the other sheet??
Pls do clear this and Talend Community will be able to help you!!
Hi, Let me give more details
Row2 Data: 899;999;677
Row2 Data: 456;321;124
Output - I need to take specific data fields above and place them in the specific output column and rows. Example below
This is knowledgeable post its really helpful for me and getting some of the new chance for it. New innovation for design Do my Essays
For this requirement you can join the sources and filter the columns by populating only Xeon data column onto your target.
Tmap(Filter condition for pulling "Xeon" column) --------> target
Pls do get back to Community,if you are facing any issues.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema