Interface Tool to allow user to select folder paths

Question

I would like to convert a workflow to a macro that allows a user to select folder paths for where data is stored.  One input requires the user to select not only the path but the filename, and that is easy with a File Browse tool.  However, I have five other inputs that I don't want the user to change the filename for, but they may have them placed in a different location and thus I want them to be able to identify the folder.  I don't want them having to type in the path but select it from a folder on their drive.  Is there a way to do this with an interface tool?

Thanks!

Dhilip_Kumar · Answer

Hi Pang_Hee_Choy,

I used this above workflow however i got error while using txt format. Please see attached error image and do the needful.

Error Image.docx

AncientPandaman · Answer

@NeilFisk you can mention what to keep in the action tool.

1. in the input tool - keep filename only

2. create a dropdown for selected folders (acting same to text box input)

3. merge both data with "\" in action tool

example.yxwz

rzdodson · Answer

@NeilFisk  take a look in to the Tree tool in the Interface pallet. Depending on how the directory is established, the user has the ability to select in to a specific file, or click on the parent folder and select every file within that directory folder. I have attached a couple of pictures of how I set up a tree tool for a generic use case.

What you'll need is a database file that has the structure of your directory, which will be used in the "File/Database Path/Connection" portion. Then, you'll need to tell Alteryx what the Key and Description fields are. The second picture attached shows the results of that configuration. Depending on the use case, you can bring in all of these file paths along with their associated data simultaneously.

Hope that helps, sir!

Tree Tool.png

Tree Tool 2.png