Reading list of files in folder

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!

Transformation

Batch Macro

Preparation

In Database

In-Database

Accepted answers

jdunkerley79

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)

Sample Analytic App.yxwz

All comments

jdunkerley79

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)

Sample Analytic App.yxwz

Eivind

Thanks a bunch for helping out! Just what I needed.

Mahadeva

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703