Run a workflow on multiple files and output the result separately for each input file

I need to run the same workflow on multiple files saved in a folder and write the output separate for each of those input files.

I have found a batch macro which can read all the files and run the workflow on it, but the issue is that it is producing a single output with the results of all the input files unioned together.

Please advise a solution !

Batch Macro

Accepted answers

NicoleJohnson

Without seeing the macro/workflow, this is just a guess, but you can usually specify if you want to bring in the filename when you input your multiple files to the workflow, and then you can use those as a grouping option when you go to export at the end of the workflow. Depending on which output method you're using, you should be able to append a filename or a field that will differentiate your file names onto the end of each file, which will create those separate files you're looking for...for example, the section at the bottom of the Output tools gives you the option of "Take File/Table Name from Field," where you can then identify if you want to append/prepend a field to create the file name, or replace the whole thing, etc.

Does that point you in the right direction?

NicoleJohnson

Absolutely! There is always the option of going the batch macro route and processing one file at a time (macros are not my particular strong suit, though there are several other macro wizards here on the Community who could point you in the right direction!)... however you might be able to achieve the same thing by making sure you group based on file name in any of your Summarize tools/etc., which would give you the sum total for each file rather than for the total across all files. I'd probably need to see a bit more of your workflow though to really troubleshoot... can you share a sample version of it with some dummy data, by chance?

All comments

NicoleJohnson

Does that point you in the right direction?

rohan_tibarewala

Thank you so much Nicole.

Your hints helped me a great deal and i am very close to getting the results as i want from the workflow.

Like you mentioned, i was able to add a field with filename using "Output filename as a field" in Input data tool and also the outputs are grouped using Output data tool, based on those file names perfectly.

However, I have hit another bump for now and hoping more of your help.

In the final output i have noticed that the formulas/tools in the workflow seems to have run after taking the entire data together from all input files and then just the output is split based on file name. I was hoping that the workflow would run on each input file individually and produce the output for each file. To achieve this i tried placing 'Block until done' tool at different stages of workflow but without any luck.

For ex. I need to calculate the sum of field 'A' for each input file (lets say it would come 100 for File 1 and 200 for File 2) and i want to see this result in output of both the files. But instead i am seeing the sum only on File 2 as 300.

Hope my query is clear.

Ty25

Thank you Rohan for posing the question and thank you Nicole for the time saving answer

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703