Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Directory input ; file path with sheet name

7 - Meteor



Is there any way that I can open the several files by directory tool and get full path with each sheet name? Thank you!







20 - Arcturus
20 - Arcturus

You might want to check out @ned s blog post. 



Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Alteryx Alumni (Retired)

Hi Stacy,


If you are on v10, then the way to do this would be to read the directory in using the directory tool and then feed that into a dynamic Input tool, with <List of Sheet Names> selected as the sheet on the template in the Dynamic Input tool. That will return a list of sheets for each file, which you can then use a formula tool to make the filename|Sheetname combo you need. So in the Dynamic Input, your settings for the template will look like this...


Image 001 - 20151116 - 111143.png



6 - Meteoroid

Hi Team,



I have a scenario where i have multiple folders inside a folder and all those multiple folders have many excel files in it .

Below is the screenshot for better understanding -



want to automatically access the all the folders and all the excel files inside it .


Please let me know how to achieve this.



Swati Sharma

8 - Asteroid



Use a Directory Tool and make sure the configuration is set as per below where file specification is your file type and you select the sub directory checkbox to include the files from your sub folder as per your requirement.



Then select the dynamic input tool and make sure the configuration is as per below,



This will work if there is one sheet in each of your excel files.


If there are multiple sheets in your excel file then you will get an error on your dynamic input tool which will say "No sheet specified"


Follow the answer which has been marked on this question.


I hope this helps!


Kind regards,


7 - Meteor

Hi Mishal,

Do you know what is the workaround if there are multiple sheets in the excel files?




Alteryx Alumni (Retired)



I'm not sure that I understand your question. The above works with Multiple sheets in the Excel file.