input multi excel folder with different name on tabs

Hello,

I'm facing a problem in pulling tabs with similar names from multiple excel files with different names and different folders. I also tried to create a dynamic input with drop down and action apps but am not able to link them up to choose the different locations.

Is it necessary to have one folder containing all the excels.

I've tried looking for a solution in the community but am not able to find one. I am relatively new to using alteryx and would appreciate any guidance.

Thanks.

Common Use Cases

Apps

Preparation

Accepted answers

JordanB

Hi @Prab

Attached is an example of a reading from the top level folder which contains the 40 different folders. This method uses the wildcard function in the file path to search a directory.

Assumptions

- 40 folders under one parent folder

- Is only able to read the one tab with the same name

Please provide more detail around your file structure if this isn't quite what you are looking for!

Best,

Jordan Barker

Solutions Consultant

Read_from_folder_one_Sheet.yxzp

All comments

JordanB

Hi @Prab

I think initially it would be useful to use @CameronS excel macro input which will allow you to read in all excel files and tabs from a certain folder.

You can replicate this process for each folder you have to simplify the process.

Once you have written all the data in from the various different folders you can use a union tool to bring the different data streams together.

This one tool will give you a good segway to understanding more about the batch macro process which is used within Alteryx to read a list of values (file paths in this case) at once.

Best,

Jordan Barker

Solutions Consultant

Prab

Thanks Jordan.

Cameron's solution is limited to one folder and multiple excel files and tabs.

The problem I have is a slight variation of the same.

The problem is that I just have one excel file per folder and need to read just one tab (maybe more in the future) from each. But these single excel files lie in 40+ different folders. Is there an alteryx solution to have just one app with a drop down selection of what folders and files to run ?

Thanks again.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703