https://community.qlik.com/t5/Talend-Studio/Handling-multiple-schemas-in-a-single-job/m-p/2222136#M15858 <P>Hello all,</P><P>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.<BR />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.</P> Sat, 16 Nov 2024 02:07:47 GMT ecurren-lmi 2024-11-16T02:07:47Z https://community.qlik.com/t5/Talend-Studio/Handling-multiple-schemas-in-a-single-job/m-p/2222136#M15858 <P>Hello all,</P><P>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.<BR />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.</P> Sat, 16 Nov 2024 02:07:47 GMT https://community.qlik.com/t5/Talend-Studio/Handling-multiple-schemas-in-a-single-job/m-p/2222136#M15858 ecurren-lmi 2024-11-16T02:07:47Z https://community.qlik.com/t5/Talend-Studio/Handling-multiple-schemas-in-a-single-job/m-p/2222137#M15859 <P>Hello,</P> <P>tFileInputExcel component supports Use Regex to set the sheet name.</P> <P>You could enter "*ALL Data" (including the quotes) in the "Sheet list" area then tick the "Use Regex" option.</P> <P>Best regards</P> <P>Sabrina</P> Fri, 19 Jun 2020 09:23:17 GMT https://community.qlik.com/t5/Talend-Studio/Handling-multiple-schemas-in-a-single-job/m-p/2222137#M15859 Anonymous 2020-06-19T09:23:17Z