Reading list of files in folder
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
To make a workflow more dynamic and easy-to-use for others, I'd like to start it by having Alteryx asks the user to browse to the folder containing the input files, and then generating a list of all the filenames in that folder. I then have a batch-macro that will read all these files into a database for further analysis.
The problem is then: How can I make a workflow that gives the user a browsing window, then makes a list of all files in the user-selected folder?
I think Alteryx has this capability, but not been able to figure it out yet. Any thoughts appreciated!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can create an Analytic App and have a Folder Browse in it.
Take a look at: http://www.alteryx.com/resources/creating-analytic-apps-with-alteryx-analytics
Will do a quick sample at lunch
Simple sample attached. Scans for CSV files and saves list.txt. (Saved in 10.5 should you need 10.0 will hack the file)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks a bunch for helping out! Just what I needed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm working on a similar app, but am having trouble when selecting Excel files using the File Browse. It doesn't give the option to choose a sheet, as far as I can tell. I've tried adding a second input to generate a list of sheet names, but it won't update the list of sheet names until the workflow processes, and retains the initial file choices list of sheet names. Is there any way to select a sheet name, or provide a drop down that will update with the sheet names after the file is chosen? I'm confused because I got the drop down to work just fine when choosing a field, and I manipulated the list of sheets so that each sheet was the name of the field, expecting that to work, and it does, it just doesn't update the drop-down.
Any help is appreciated. There might be a simple solution to choose a sheet I'm just missing.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi jdunkerley79,
Your flow works fine within alteryx tool, but app cannot be hosted in Gallery since it doesn't support Folder browse.
Appreciate if you can let us know a workaround for using this folder browse option in Alteryx app hosted in Gallery.
Regards,
Mahadev
