Directory Tool Usage for Multiple Inputs

[JSheppard98]

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

[ShankerV]

Hi @JSheppard98 

Yes, its possible.

Step 1: I would recommend to input the Directory Tool. It allow return all the metadata related to the files which exist within that folder with 'Creation Time'.

Step 2: Use Sort tool, to sort based on the creation time.

Step 3: Use Sample tool to filter 1st 6 records.

Step 4: Use Dynamic Input

You have your output.

Many thanks

Shanker V

[JSheppard98]

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 

[ScottE]

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]

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