Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Talend beginner here. I have a job where I need to read data from multiple tabs in an excel file (All tabs have a different schema). Then, I need to filter that data based on certain requirements and export that data to an excel sheet with multiple tabs.
Here is an example of what I was thinking:
I was going to setup up 5 sub-jobs, each with its own metadata based on the corresponding tabs, then save that data to the same excel file with 5 different tab names for the sheets. Then use tRunJob to run all the sub-jobs at once. The big issue I am having is that I am unable to get the data to save to each tab, only the data from the last job is saving.
Not sure if I am on the right track, or completely off base, but any help would be appreciated.
Hi Dijke,
Thanks for the quick response and suggestions. Glad to see I was on the right track with the sub jobs at least. I did want to clarify the job, in case that changes things. There is an excel file that gets placed on a share drive daily; the job would read that file, filter data on certain tabs then create a new excel file with the filtered data.
Our end goal is to have this run automatically so the user won't have to do it, which is why we were looking at Talend. If it's not possible then we can look at other options.
Appreciate the help! Thanks again!
>>
The big issue I am having is that I am unable to get the data to save to each tab, only the data from the last job is saving.
>>
There is a checkbox in the excelOutput component, where you can select whether you want to create a new file or append
to an existing. You prohably left this checkbox unchecked. So in every subjob a new empty excel file will be created.
That explains why there is just the data from your last run/subjob.
For the first subjob you should leave this checkbox unchecked -> excel with first tab is created.
For runs 2-n select it -> excel will stay as it is and new tabs with data will be appended.within each subjob
regards
Thanks odisys, I was able to get the data to write to separate tabs, appreciate it!