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

[Gorazd]

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.

[lbardoe]

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]

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]

This might help with the batch macro option! The Ultimate Input Data Flowchart - Alteryx Community entrée de données eingabedaten