Error When Reading Multiple Excel Files in a Batch Macro

[ccskoga]

I am using workflows and batch macros.

In the workflow, multiple Excel file paths are passed to the batch macro.
In the batch macro, it opens the Excel files based on the received file paths.

However, an error occurs in the batch macro stating, "The field schema changed between iterations," likely because the layout (columns) of the Excel files is not entirely identical.

Could you please let me know if there is a way to resolve this issue?

[Qiu]

@ccskoga 
Check this post.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Import-Multiple-sheets-in-from...

[nagakavyasri · Accepted solution]

@ccskoga Change the Macro configuration View->Interface->Auto Configure by Name

[ccskoga]

I would like to thank @Qiu for taking the time to provide a response to my question.

And I wanted to express my gratitude to @nagakavyasri for providing a solution to my issue regarding the error when reading multiple Excel files in a batch macro.

Thanks to your guidance, I was able to resolve the problem successfully. Your explanation was clear and incredibly helpful. I truly appreciate the time and effort you took to assist me.

Thank you once again for your support!