topic Re: One excel file input on multiple sub jobs in Talend Studio

One excel file input on multiple sub jobs

Anonymous — Thu, 20 Aug 2015 20:22:57 GMT

How can I use one excel file input on multiple sub jobs without copying the excel file under each sub job?

I wan to use the Encounter_Key File on both sub jobs and am not able to link it to tmap4 on the second sub job

Re: One excel file input on multiple sub jobs

Anonymous — Thu, 20 Aug 2015 21:04:55 GMT

What do you mean "without copying the excel file under each subjob?". Do you not want to use a tFileInputExcel reading the Excel file more than once? There is no issue with doing that so long as you are not reading it twice at the same time. In separate subjobs you won't be doing a simultaneous read.

Re: One excel file input on multiple sub jobs

Anonymous — Thu, 20 Aug 2015 21:22:49 GMT

I was hoping to use the one excel file on the first sub job for the rest of the sub jobs as a source file by reading it twice.
I can copy the same excel file to each sub job as a source. I was trying to avoid that.

Re: One excel file input on multiple sub jobs

Anonymous — Thu, 20 Aug 2015 21:52:23 GMT

You misunderstand what is happening. You are not copying the file, you are just reading from it. The tFileInputExcel just reads the file. So if you use two of those components in separate subjobs, you are just reading from the file in each of the subjobs.
I note from looking at your screenshot that you have not linked the subjobs. You should link the subjobs from the start component of the first subjob to the start component of the second subjob using an "OnSubJobOK" link.