Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

WARNING: * ... has a different schema than the 1st file in the set and will be skipped

Gorazd
5 - Atom

I am attempting to process multiple Excel files (forms).

 

When using "Data Input," I receive multiple warnings stating, "... has a different schema than the first file in the set and will be skipped."

 

Is there a way to ignore these warnings so that the files are not skipped?

 

The differences between the files lie in the type and size of the strings.

3 REPLIES 3
lbardoe
8 - Asteroid

Are these excel files or are they csv/text files. If its excel then specify a range thats greater than the largest spreadsheet eg Sheet1$A1:AZ. If its csv then import them as FLAT files specifying the character as say 1000 chars then use the Text To Columns function to split the data by the delimiter.

glenebb
7 - Meteor

Another way would be to input it through a batch macro and change the Output mode in Interface Designer (Ctrl + Alt + D) to Auto Configure by Name (Wait until all iterations run)

alexnajm
17 - Castor
17 - Castor
Labels
Top Solution Authors