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?
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.
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.
