Run one file at a time through workflow

Question

Hello,

I have a set of .csv files in a directory that need to run through a workflow one at a time. It seems like the correct way to do this is a macro, so I added a control parameter above the Input Tool and set the Action Tool to Update Value > {the file name}. I set the Workflow Type to Macro and ran it, but it only runs the 1st file in the directory through the workflow. I'm not sure what on my settings is incorrect, appreciate any guidance you can share.

Thanks,

Jackie

T_Willins · Accepted Answer

Hi @JUUP,

Without seeing your workflow it is hard to diagnose the exact cause, but is your macro now a tool in another workflow?  Just saving a workflow as an iterative macro will not make it iterate unless part of another workflow.  Running the macro stand-alone only makes it run once.  What you are describing, though may be better suited for a batch macro, but even then there may be a simpler solution.  If all the data in the .csv files is the same format, can you bring in all files at once, include the filename as a field, then use the filename to parse the data into separate outputs?