Different Schema error from some of my excel files

[zachritter00]

I have a workflow I've built that is using a wildcard (*.xlsx) at the input tool to pull all excel files from a folder. There are 17 files, and 6 continue to error out and skip due to "different schema".  However, all 17 files have 1 tab with the same name and have the exact same setup for the columns.

Is there a way to figure out or troubleshoot why those 6 files are getting skipped?  They have some conditional formatting in them to help the end user correctly input their data before the workflow, could that be affecting it?

[Raj]

@zachritter00 if you use the batch macro you can read all the files (even if there are different schema) and once data is loaded you can see the difference

Hope this helps

Mark done if solved.

[zachritter00]

I haven't done a batch macro before.  I'll go start reading on how to do one

[binuacs]

@zachritter00 try batch macro, you can refer the below post and try the attached batch macro 

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

[zachritter00]

Thank you.

I've added the batch macro, but am still getting an error - 

Batch Correct (818) Record #1: Tool #1: Unable to open file for read: C:\Users\test folder\.849C9593-D756-4E56-8D6E-42412F2A707B

I understand that's the default test file that comes with the batch macro, I updated the directory input tool on the canvas to the folder all the files are in, and opened the macro to update the input data tool to aim at the first file in that folder.  What am I doing wrong?