Assist with Dynamic Input

Question

Hi all  - I am fairly new to Alteryx but need to get up and running soon. Therefore, I am hoping someone can help me with the Dynamic Input functionality and options to output.

I have attached a pic of my workflow. My current workflow allows the user to input only one file. Firstly, I would need to let the user(s) input multiple files (from different folders within their computer). All of the files will use the same workflow/logic in the container (attached). Second, the output file (excel) is expected to populate the results in a separate sheet/tab for each input file.  Finally, (optional) if the sheets can be named as the input file name that would be a bonus for me :) . Please let me know if I am unclear. I appreciate your time and consideration.

Thank you

Alteryx workflow SB.JPG

AbhilashR · Answer

Hi @itssumanb, as @atcodedog05  mentioned, the Directory tool brings back metadata of all files within a folder which gives you the flexibility in terms of the number of files you read in.

atcodedog05 · Answer

Hi @itssumanb

I can see @AbhilashR is using Directory tool to read files.

Directory tool will get all the filenames in the selected folder irrespective of number.

Hence it should work.

https://help.alteryx.com/current/designer/directory-tool

Hope this helps 🙂

itssumanb · Answer

Hello - thank you so much and sure this will help me get started. To answer your question - The # of files won't be the same always but I know they will be about 5, 6, or 7 files to run at a time.