This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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 ?