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

[abhi90]

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 

[Anonymous · Accepted solution]

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

[abhi90]

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?

[Anonymous]

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