topic Re: Issue while transferring data from MSSQL to Excel of multiple sheets in Talend Studio

Issue while transferring data from MSSQL to Excel of multiple sheets

Anonymous — Tue, 08 May 2018 04:53:49 GMT

I am pulling data from MSSQL database and loading it in excel. This excel is having multiple sheets where each tables data will be loaded. Excel is already having some information in the top (top 3 rows) written about the business and then the columns start.

When i tried to pull the data from one tables and store it in one sheet in the output using fFileOutputExcel, i am losing other sheets. Some of the sheets are having some coding to calculate aggregation/sum/differences etc. Can you please help me to achieve this? Let me know if you need anything from me. I had selected "Append existing file" and tried lot many options available in the fFileOutputExcel component but in vain. Please help

Re: Issue while transferring data from MSSQL to Excel of multiple sheets

Anonymous — Wed, 09 May 2018 10:24:22 GMT

Hello,

Your multiple sheets have the same schema? If you want to create multiple sheet in tFileOutputExcel, the job design should be:

t<DB>Input_1-->tfileoutputexcel_1(sheet1)

onsubjobok

t<DB>Input_2-->tfileoutputexcel_2(sheet2)

both are same except the sheet name.

Best regards

Sabrina

Re: Issue while transferring data from MSSQL to Excel of multiple sheets

Anonymous — Wed, 09 May 2018 10:26:30 GMT

Thanks Sabrina, its resolved.