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!
... View more
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.
... View more