Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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