Error : "has a different schema than the 1st file in the set and will be skipped"

[dpuls]

I keep getting the following error when reading a half dozen small Excel workbooks using a Data Input tool set to read *.xlsx from a specific folder. I have checked the Excel worksheets for format differences (header/footer, column headers, hidden columns, etc) and cannot find what is different if anything.  I have even entered the scores from one survey response worksheet to the one that works and renamed/saved - still to no avail.  I'm am definitely pulling my hair out over this one.  

Anyone seen something weird like this occur before?  Thoughts about how to troubleshoot?   I have to process a fairly large number of worksheets in te next day or so. Open to any and all ideas... Thanks.

Warning: Input Data (1): The file "C:\Users\dennispuls\Desktop\Working Documents\XXX\CapMat Survey\XX Cap Mat Responses\R2 - 03.21.2019 - XX IT Capability Maturity Survey_XXX|||`Survey$`" has a different schema than the 1st file in the set and will be skipped

[CullenG]

Do you have a workflow I can see?

[LenaDVVR]

Hi everyone,

I have the same issue but with the tool "Select" at each CSV input, all data seem to be the same (double for one, and double for the other). 

Can you share the name of the macro please ? I would like to figure it out and I am convinced that only the macro can solve this issue. 

Thank you in advance, 

[VikramNalawade]

Thanks @CharlieS . This suggestion helped me as well. For reference of other, below is the screenshot of small batch macro created. The 'Select' tool before Macro Output helps align the 'schema' like datatype and length of output data from all files.

[geraldngugi]

Would love a demo of this please

[111xyz]

Great! please could you share the WF so that I can see the macro you used? 

[geraldngugi]

Hi  - I managed to solve this recently by following the instructions here >>> https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

My batch macro looks as simple as this: 

Hope that helps!

[JACKIEC1992]

Hi there

I am running into the same error and cant seem to find a solution. I have one file that I need to spit out into one output. I sometimes do or do not run into this error and would love to figure out a quick fix for this. I am attaching the workflow and also the input file. Any suggestions would be appreciated!

[Rajivraghava]

I dont see any difference in the fields not sure if i am missing a step here my friend

[beatrice_favella]

I was having the same problem, but after reading this post I realized that the same field was considered as text in some files and as number in others.

I fixed the problem! thanks.

[bmoss]

This comment was really helpful and led me to a solution. I was able to avoid creating a macro by setting the dynamic input tool to grab data staring at the first row, which forced all fields into strings. Then Dynamic Rename Tool to grab the field names back and select tool to update datatypes.