Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Looping on a directory of excel files to read them all

MoustafaHebisha
5 - Atom

I created a workflow that works fine with excel files i just need to loop on a directory to apply what i have done on one excel file to the other 32 files so all i need is just an iterative container or something 
i don't know how it can be done in Alteryx designer 

4 REPLIES 4
geraldo
13 - Pulsar

@MoustafaHebisha 

 

A question:
Does all excel internal worksheet have the same name?

MoustafaHebisha
5 - Atom

Yes they all start with AMDD but if you are seeking using wildcards (*) it won't work because they have different schemas 

binuacs
21 - Polaris
geraldo
13 - Pulsar

@MoustafaHebisha 

 


In this example I'm putting subdirectories to read the root folder in the directory tool and I'm putting excel files starting with "es" to read.
Perhaps the example will help you to make the necessary adjustments .

 

attached workflow

 

 

geraldo_0-1683204510933.png

 

Labels
Top Solution Authors