https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-read-multiple-tab/m-p/2283233#M57196 You can not read directly using tfilieinput excel with static schema , you can try to use dynamic before that you need to take the sheet names and iterate and pass the sheet name to tfileinputexcel with dynamic schema. <BR /> <BR />tfixedflowinput to pass the hard-coded values of sheet names and iterate using tflowiterate and tfileinputexcel using the global variable of tflowtoiterate as a sheet name. Mon, 06 Apr 2020 03:34:10 GMT manodwhb 2020-04-06T03:34:10Z https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-read-multiple-tab/m-p/2283232#M57195 <P>Hi</P><P>I have an excel sheet and it has two tab. Each tab has different schema structure. Can i read read two tab with different schema structure in single tFileInputExcel component?</P><P>Thanks</P><P>Saswata</P> Mon, 06 Apr 2020 00:26:41 GMT https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-read-multiple-tab/m-p/2283232#M57195 Anonymous 2020-04-06T00:26:41Z https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-read-multiple-tab/m-p/2283233#M57196 You can not read directly using tfilieinput excel with static schema , you can try to use dynamic before that you need to take the sheet names and iterate and pass the sheet name to tfileinputexcel with dynamic schema. <BR /> <BR />tfixedflowinput to pass the hard-coded values of sheet names and iterate using tflowiterate and tfileinputexcel using the global variable of tflowtoiterate as a sheet name. Mon, 06 Apr 2020 03:34:10 GMT https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-read-multiple-tab/m-p/2283233#M57196 manodwhb 2020-04-06T03:34:10Z