Open Multiple Excel Using Macro

Thordust16

Hello,

While running a batch macro to open multiple excel files I notice an error message mentioned below.

Few files data is not loading due to this error, any help is appreciated.

BatchMacro.PNG

BenMoss

Well the problem is informing you of the exact issue, your files appear to very in schema (that be number of columns, headers, header positions or data type).

In a batch macro you can set your configuration to ignore a different schema error in the interface designer.

Alternatively I would just use the macro from this post...

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/CS-Macro-Dev-Reading-in-multiple-files-with-different-Field/ta-p/13370

Ben