Batch Macro Help

Question

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?

Input into Macro.png

Macro in WF.png

JosephSerpis · Accepted Answer

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.

JosephSerpis · Accepted Answer

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