Batch Macro Help

[StephenBurns]

I am running a batch macro on 15 files to cleanse and stack the data to run through a WF. The files all have the same tab from which the data is coming. When I run the macro and introduce it back into my workflow, I see that 15 iterations of the macro were run; however, when I look over the data, it is only the information from the first file that is repeated 15 times. Does anyone know how I can get it so that the output of the macro is stacking all 15 files and not the first file 15 times?

[JosephSerpis · Accepted solution]

Hi @StephenBurns from the picture of the setup of your macro in your action tool you need to click on File - Value instead of Input Data. 

[StephenBurns]

Ok, I have made that update and am receiving the below errors when running the workflow.

[JosephSerpis · Accepted solution]

Hi @StephenBurns try adjusting the setting of the macro in Interface Designer. Try Auto Configure by Name.

[StephenBurns]

HI, thank you for the assistance! It is outputting all 15 iterations now.