Schema error during file import

[sharmilaj]

Hi all,

I'm trying to import bunch of files in the folder of same formatting. The Alteryx takes only few files and skipping saying this error "Warning: Input Data (1): The file ".xlsx|||`Sheet1$`" has a different schema than the 1st file in the set and will be skipped"

Is there a way to fix this without macros. 

[apathetichell]

There are three ways to fix this:

1) Use a batch macro.

2) Go into the offending Excel sheet. Identify the issue with the column - is it naming - does it have an extra space? Does it start at the right line? Is it type (ie Alteryx is expecting a string and it's a number)?

3) bring in that file separately and then union it - deal with whatever issue Alteryx is flagging in workflow.

That's it. To be clear - I'd go with option 1.