Different Schema error from some of my excel files

Question

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?

zachritter00 · Answer

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	est folder\.849C9593-D756-4E56-8D6E-42412F2A707BI 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?

binu_acs · Answer

@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 · Answer

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