Alteryx Designer Discussions

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

Directory input ; file path with sheet name

Stacy
7 - Meteor

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!

 

 

 

 

 

 

6 REPLIES 6
MarqueeCrew
20 - Arcturus
20 - Arcturus

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 restart. Order shall return.
Please Subscribe to my youTube channel.
KaneG
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

 

Kane

swatisharma32
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 -

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

mmishal001
8 - Asteroid

@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

Ragini
7 - Meteor

Hi Mishal,

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

 

Thanks!

Ragini

KaneG
Alteryx Alumni (Retired)

@Ragini,

 

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

Labels