topic Transferring data from multiple sheets excel file to multiple tables in Talend Studio

Transferring data from multiple sheets excel file to multiple tables

_AnonymousUser — Tue, 27 May 2014 18:26:58 GMT

I want to transfer data from Excel to SQL. My Excel worksheet has 20 different sheets having data to be copied in 20 different tables.
I want to create a single job to perform this task in a step by step manner.
My tables have dependencies so it is very important to copy data to these tables in a specific order.
I want to have 20 steps in a single job.
Any help (online source / video) regarding how to go about this task would be appreciated.

Re: Transferring data from multiple sheets excel file to multiple tables

Anonymous — Tue, 27 May 2014 20:55:00 GMT

This is indeed a very simple task.
You have to create as much as you have sheets these kind of subjobs:
tFileInputExcel --> tOracleOutput
You question sounds like you do not have invested not so much time to learn the tool yet.
I have never seen a tool what does not depend on an amount of time to learn it.
I suggest you start with a single sheet and a single table if you got it you could reproduce it for all of your sheets and tables.

Re: Transferring data from multiple sheets excel file to multiple tables

_AnonymousUser — Tue, 27 May 2014 21:49:46 GMT

May be my question was missing the proper details.
I have started with the single sheet. But with the multiple sheets I needed to maintain the order in which I copy the data as tables were related.
I have managed to do that. I have used trigger -> OnComponentOk from the first table's output to the second table's input. And so on.
Thanks.

Re: Transferring data from multiple sheets excel file to multiple tables

Anonymous — Wed, 28 May 2014 05:43:09 GMT

I would recommend to use OnSubJobOk link from input component of your first table data transfer. This will ensure that table data load is executed after completion of first table data load.
Thanks
Vaibhav

Re: Transferring data from multiple sheets excel file to multiple tables

Anonymous — Wed, 28 May 2014 08:27:38 GMT

Hi Yuvraj Solanki,
Please have a look at KB article about TalendHelpCenter:What is the difference between OnSubjobOK and OnComponentOK??
Best regards
Sabrina

Re: Transferring data from multiple sheets excel file to multiple tables

Anonymous — Wed, 28 May 2014 09:16:10 GMT

you have to design job like below to solve this issue.
openDbconnection---oncomponentOk----tFileInputExcel(sheet 1)------tSQlOuput
and add rest of sub jobs using subjobok link. refer image for more details.

Re: Transferring data from multiple sheets excel file to multiple tables

_AnonymousUser — Wed, 28 May 2014 14:10:06 GMT

Thanks for replies.
I got the difference between OnComponentOk and OnSubJobOk.
I think any approach will work in my case but with your views I learned the better approach to design my job.
Thanks,
- Yuvraj.

Re: Transferring data from multiple sheets excel file to multiple tables

Anonymous — Thu, 29 May 2014 08:44:18 GMT

Hi Yuvraj Solanki,
Great you can get more from this use case. Shall we mark this topic as "resolved" so that other community users will be informed that this thread has been resolved.
Best regards
Sabrina