Directory Tool Usage for Multiple Inputs

Question

Hi there,

Just wondering how I would go about using the directory tool to find the below 6 files which are required on a daily basis? As I require them currently in a daily workflow to prep the data and consolidate it into 1 excel file with multiple tabs as my output data. So currently have been downloading the 6 new files, inputting them manually and then running the workflow.

But is there a way that I can get these to auto pull the latest downloaded file in a given folder?

Thanks

JSheppard98 · Answer

Appreciate the help also. Managed to get the below working which is great. Now I just need to figure out a way to auto download these attachments from outlook to the said folder haha

ScottE · Answer

Hi @JSheppard98

Yes, you’re on the right track.  I would suggest repeating this Directory tool process for each group of files that have the same structure.  Looking at your original screen shot you might be able to use one for the 4 files you’re unioning together and another for the 2 AC Holder files.

The Dynamic Input will automatically Union the files together so you’ll need to alter your workflow accordingly.

The set up of the Dynamic Input requires a template, so it knows what data schema to expect.  I will typically use one of the files I’m trying to input as the template.  You can find more information on the Dynamic Input configurations in the help.

https://help.alteryx.com/20223/designer/dynamic-input-tool

I’d also suggest checking out the sample workflow if you haven’t already.

Hope that helps,

Scott

JSheppard98 · Answer

Would it be like something below? What selections would I put in my dynamic input tool sorry. Would this then connect to my original workflow straight to the data cleansing/or other sample bits in the original screenshot?

Thanks for the quick reply