Run existing workflow for different filter value and get a different output file

[IGHETU]

I have a workflow that uses 2 input files to perform a reconciliation between GL and another report for one specific local account (for which I use a filter). This workflow results in an Excel output file with multiple sheets. I would like to be able to run the workflow for 15 local accounts and get a different Excel output file for each local account. Any suggestions how I can achieve this?

 

[FrederikE]

Hey @IGHETU,

You can use a single Output Tool to write all 15 Excel Files and its sheets. You just have to create the file/sheet-names in the flow.

Select to change the File name, it should be Excelfilename|||Sheetname (||| <- is the separator for the sheet). This will write seperate files with multiple sheets. Select the column that contains the Names in the Configuration of the Output-Tool.

[IGHETU · Accepted solution]

I am doing that atm. The worflow results in Output file  Local account 1642 with 4 different sheets. What I would like to achieve is to run the workflow for 15 local account  change the filter on both input files to (1601, 1602...) and have for each local account a different output file with those 4 sheets. Would a batch macro work in this case?