Iterative canvas execution with different files with every iteration

[Sauravdugar]

Hello All, 

I have very specific use case where the canvas has to run with 4 excel (xlsx) files using 4 differnent input tools. My canvas is running just fine, but I have 2000 such excel files in the folder where I need this group of 4 files to be picked up and the canvas executes them group by group (group of 4 files) and not have a user run the canvas over 200 times. The 4 input file follow a standard naming convention as per below. Any suggestion as to how this may be achieved?

apple-File1-01162025.xlsx

apple-File2-01162025.xlsx

apple-File3-01162025.xlsx

apple-File4-01162025.xlsx

orange-File1-01162025.xlsx

orange-File2-01162025.xlsx

orange-File3-01162025.xlsx

orange-File4-01162025.xlsx

Many Thanks!

[alexnajm]

A Directory tool is the best place to start, followed by whatever logic you need to get it down to your groups. finally, a batch macro can read in the data from the paths - this one is the most useful place to start: The Ultimate Input Data Flowchart