topic Re: Talend Newbie - Excel report in Talend Studio

Talend Newbie - Excel report

TalendBasketball65 — Fri, 04 Jan 2019 19:41:15 GMT

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,

Re: Talend Newbie - Excel report

Anonymous — Mon, 07 Jan 2019 08:38:20 GMT

Hello,

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

Best regards

Sabrina

Re: Talend Newbie - Excel report

ankit7359 — Mon, 07 Jan 2019 10:47:09 GMT

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

Re: Talend Newbie - Excel report

TalendBasketball65 — Mon, 07 Jan 2019 21:43:38 GMT

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,

Re: Talend Newbie - Excel report

Anonymous — Tue, 08 Jan 2019 08:05:29 GMT

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

Re: Talend Newbie - Excel report

ankit7359 — Tue, 08 Jan 2019 09:28:23 GMT

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.

Re: Talend Newbie - Excel report

yewogley — Mon, 24 Oct 2022 08:51:49 GMT

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.