I am trying to create a way for a user to input a root folder that contains excel and csv files that they want to feed into the rest of the workflow. My idea was to use a folder browse tool to allow the user to put the path of the folder in. From there, a list box would dynamically change and list all of the excel/csv files contained in that folder. When ran, the selected files would flow to the rest of the workflow. Below is a picture of what I have put together.
The issue I am having is that the user inputted folder isn't flowing to the list box and it won't dynamically change. The user interface shows the box to input a folder and shows the options to select the files from the directory being used in the workflow.
Thanks in advance for your help!
I believe the issue is that the interface tools load at the same time and your list box will not update because your selection has not passed through the workflow yet. You can use a chained app to get around this. The output of your first app would be the folder path. The rest of the workflow would be the second app.
@epaul2
Refer this video
this will help
How To Use Chained Apps in Alteryx Designer (youtube.com)
someone asked about something a bit similair last month and I created a chaned app sample using a tree tool to allow selection of specific files from the first directory. not exactly your case but feel free to check it out as one way to select a directory and then a file. note - I didn't add the third app which would read in the file - I'd recommend creating a methodology for handling (ie this expects excel files- and only excel files).
