community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Directory input ; file path with sheet name

Atom

Hi,

 

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

 

 

 

 

 

 

Alteryx Certified Partner
Alteryx Certified Partner

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

 

http://community.alteryx.com/t5/Engine-Works-Blog/Alteryx-Reading-XLSX-Directly/ba-p/2190

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Alteryx
Alteryx

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

 

Kane

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 -

1.PNG2.PNG

 

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

 

Please let me know how to achieve this.

 

Thanks,

Swati Sharma

Meteor

@swatisharma32 

 

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.

mmishal001_0-1573893635866.png

 

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

mmishal001_0-1573898932734.png

 

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,

Mishal

Labels