How to input multiple excel with similar filename in different folders

Question

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

JosephSerpis · Answer

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

caltang · Answer

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.