Looping input files

TMEY_dec

Hi everyone,

I'm modelling some transport data for work. We have 7 different options, each option with 3 project years meaning that we have at least 21 different input files to run and therefore 21 output files. I'm wondering whether there is a way for our workflow to automatically move to the next input data file after completion and create a new output file without me having to manually update the Input Data file (or have to duplicate the entire workflow). 

As it stands, we have three different 'Base Case' input files (i.e. one for each project year), 21 'Project Case' input files (i.e. 7 different options, each having three different project years), and then a 'Fixed Input' input file which will not change.

All of our file names are named consistently e.g. 'TransportModel_Y2026_Base Case' and 'TransportModel_Y2026_Option1' and are all held in the same file directory. The data within Input data file are all named consistently.

Would love  to hear some tips or solutions!

Thanks,

Dec

fmvizcaino

Hi @TMEY_dec ,

Attached is an example showing how to do that with excel files with multiple tabs. Since I don't know your file format, I'm sharing you this complete solution where I'm using the first dynamic input to get all sheets and then the next dynamic input tool to open files one by one. Then, my output data tool is configure to get the [FileName] column and create one file for each different [FileName] data.

If you don't need to open sheets with multiple tab names, you can skip the first formula tool and the first dynamic replace.

LEt me know if that makes sense to you.

Best,

Fernando Vizcaino

Multiple tabs and same schema - one output per file.zip