Handling multiple schemas in a single job

[ecurren-lmi]

Hello all,

I have a project that is importing an Excel workbook with 14 worksheets. Each worksheet has a different schema. The steps for processing each worksheet are the same. I am looking for a way to run each worksheet with its own schema through a job without having to make copies of that job for each schema.
I’m working with subscription version of Talend Studio 7.3, so I have access to the dynamic schema. I’m new to Talend and would really appreciate some help in how to best accomplish this.

[Anonymous · Accepted solution]

Hello,

tFileInputExcel component supports Use Regex to set the sheet name.

You could enter "*ALL Data" (including the quotes) in the "Sheet list" area then tick the "Use Regex" option.

Best regards

Sabrina