topic Re: Read From Multiple Sheet of an Excel having same Schema and Load into Different Excel in Talend Studio

Read From Multiple Sheet of an Excel having same Schema and Load into Different Excel

abhi90 — Sat, 16 Nov 2024 04:53:19 GMT

Hi All,

I have an Excel where 3 Sheets is present having Same Columns i.e. ID,NAME,Address. I want to load into 3 Different Excel reading from 3 Different Sheets. Can it be achievable? @rhall , @nthampi

Re: Read From Multiple Sheet of an Excel having same Schema and Load into Different Excel

Anonymous — Thu, 22 Aug 2019 14:46:53 GMT

Hi,

The most easy method is as shown below since you are having same schema.

You can also do the same process by iteration of files (meaning processing one file at a time). But in this case, you will have to pass the file names and sheet names as parameters to input file component.

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: Read From Multiple Sheet of an Excel having same Schema and Load into Different Excel

abhi90 — Fri, 23 Aug 2019 03:23:38 GMT

Hi @nthampi,
Once data comes to tlogrow how to populate? I mean i understood I have to pass context. filename and context.sheetname into different Input Excel Components. But how i will load Different Sheet Data to Different Excel?

Re: Read From Multiple Sheet of an Excel having same Schema and Load into Different Excel

Anonymous — Fri, 23 Aug 2019 19:45:58 GMT

Hi,

In that case, you need a control table or file which will capture the source filename, source sheet name, target filename and target sheet name. You will have to read this data as the first step and populate the data to the tFileExcel components on both input and output side.

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