Files from one Folder || Different Schema

Pascal90

Hi everyone,

We save reports from SAP into one folder and with a * in the path name we tell alteryx to take all excel files saved in that folder.

Since it's always the same report, the layout is always the same.

But we keep receiving the warning that new files are skipped due to a different schema.

So we have to import them separately, which is a manual step we would like to avoid.

I compared the metadata of the folder to the metadata of the newest files (see attached file) and everything looks fine to me.

Does anyone have a suggestions, what the issue could be?

Thank you and best regards

Pascal 

Comparison.xlsx

JosephSerpis

Hi @Pascal90 looking at your comparison file Planned Operation Short Text is a different format one is V_WString and the other is V_String. To avoid having to manually bring in those files have a look at this article the batch macro process would avoid the error you getting.