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.