Issue while transferring data from MSSQL to Excel of multiple sheets

Highlighted
Eight Stars

Issue while transferring data from MSSQL to Excel of multiple sheets

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


Accepted Solutions
Moderator

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

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

 

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

All Replies
Moderator

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

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

 

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Eight Stars

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

Thanks Sabrina, its resolved.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now