Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ecurren-lmi
Contributor
Contributor

Handling multiple schemas in a single job

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.

Labels (5)
1 Solution

Accepted Solutions
Anonymous
Not applicable

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

View solution in original post

1 Reply
Anonymous
Not applicable

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