Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Iterative canvas execution with different files with every iteration

Sauravdugar
6 - Meteoroid

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!

1 REPLY 1
alexnajm
18 - Pollux
18 - Pollux

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

Labels
Top Solution Authors