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!
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