Looping on a directory of excel files to read them all

[MoustafaHebisha]

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 

[geraldo]

@MoustafaHebisha 

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

[MoustafaHebisha]

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

[binuacs]

@MoustafaHebisha Have you tried the batch macro 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/The-Ultimate-Input-Data-Flo...

[geraldo]

@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