Talend Newbie - Excel report

[TalendBasketball65]

Hi,

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.

Thanks,

[Anonymous]

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

[ankit7359]

Hi @Talend65NCP,

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!!

Thanks,

Ankit

[TalendBasketball65]

Hi, Let me give more details

Spreadsheet 1 

Column Zeta;Tuma;Spin

Data: 4522;6788;9009

Row2 Data: 899;999;677

Spreadsheet 2 

Column Xeon;NVuma;Tpin

Data: 4560;4688;6009

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

Column  Xeon

Row       4560

Row       456

Thanks,

[Anonymous]

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

[ankit7359]

Hi @Talend65NCP,

For this requirement you can join the sources and filter the columns by populating only Xeon data column onto your target. 

Excel1(Source1) ----->

                       Tmap(Filter condition for pulling "Xeon" column) --------> target

Excel2(Source2) -----> 

Pls do get back to Community,if you are facing any issues.

Thanks,
Ankit.

[yewogley]

Thank you for the post. As a college paper help professional, I appreciate the detail and effort that went into this post. It is clear that you have a passion for your work and that you want to share your knowledge with others. I look forward to reading more of your work in the future. Thank you again for sharing your expertise with us.