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?
Solved! Go to 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.
Ok, I have made that update and am receiving the below errors when running the workflow.
Hi @StephenBurns try adjusting the setting of the macro in Interface Designer. Try Auto Configure by Name.
HI, thank you for the assistance! It is outputting all 15 iterations now.