Different schema error due to different file format

Question

I am inputting multiple files using Directory and Dynamic Input tools. The problem happens when one file is in CSV format and one file is in Excel format and even though the 2 files are exactly the same in terms of column order, it will show the error message that one file has different schema than the other. I'm trying to make sure input files have consistent format but can I built something in workflow to accept both files? Thank you.

rachelgomez · Answer

To resolve the issue you would need to review the raw data file and look at the fields in this entity and make any necessary changes before resubmitting. The schema tree diagram may assist you in identifying the correct order and consequently rectifying the issue with the file.

Regards,

Rachel Gomez

alexnajm · Answer

A batch macro should solve this issue! https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480