Macro issue- Iterations

[SH_94]

Dear Community,

I would like to ask if anyone know how to fix the error as per screenshot below.

Many thanks for the help.

[RishiK · Accepted solution]

@SH_94 

This is probably down to the fact that the number of columns or names of column headers (thus, the schema) are different between iterations.

You can fix this potentially by configuring the macro to Auto Configure by Name.

1. Open your macro

2. Select your Macro Output tool

3. on the Interface Designer panel, click on the Properties icon

4. Update the Output Mode to 'Auto Configure by Name' 

[SH_94]

Dear @RishiK ,

Thanks a lot for the prompt response and clear explanation.