Error When Reading Multiple Excel Files in a Batch Macro

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?

mc_01.yxmc

1.xlsx

wf_01.yxmd

2.xlsx

Batch Macro

Accepted answers

nagakavyasri

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

Screenshot 2024-11-28 085045.png

mc_01.yxmc

All comments

Qiu

@ccskoga
Check this post.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Import-Multiple-sheets-in-from-one-Excel-file/td-p/840836

nagakavyasri

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

Screenshot 2024-11-28 085045.png

mc_01.yxmc

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703