Dynamic schema input file

[omkarshinde]

I have a directory with multiple xlsx files with same sheet name to be extracted from all files.
For this I am using a batch macro to encounter the different schema than first error however even after configuring my batch macro and directory workflow correctly i am getting the error as No Sheet Specified.
PFA my batch macro and workflow config
ref: https://www.thedataschool.co.uk/vivien-ho/how-to-import-files-with-different-schema-using-a-batch-ma...
https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

[alexnajm]

Correct - it needs to know which sheets to read in from the Excel files. If there's a consistent sheet name, you could add it to the end of the Full Path with a Formula for example: [Full Path]+"|||Sheet1"

If there are multiple sheets, I would recommend using a Dynamic Input tool beforehand to read in a List of Sheet Names from all of the files, append the sheet names like above, and then the batch should work!

[alexnajm]

Here is a thread I helped with before that details it to an extent: Identify sheet names in multiple excel files - Alteryx Community