How to input multiple excel with similar filename in different folders

[Paddi]

Hi all,

I'm currently working on an Alteryx project which needs to input multiple excel files from different folders, for example:

ABC20231001.xlsx (\\desktop\Oct\1001\ABC20231001.xlsx)

ABC20231002.xlsx (\\desktop\Oct\1002\ABC20231002.xlsx)

ABC20231003.xlsx (\\desktop\Oct\1003\ABC20231003.xlsx)

Do you know if there are any way in Alteryx to input them at once? Thank you

[caltang]

You could use a Directory tool and tick find in Sub-Directory as well. Then it'll call all related name files as you require provided they are nested in the same folder tree.

[JosephSerpis]

HI @Paddi have a look at this article The Ultimate Input Data Flowchart it will show you how to achieve your request.