Automatic Pick Input File from a Folder

wenjuanchen

Read File Name Intelligently 

Morning everybody, I have the following scenario:

Each month there is a new input data file coming in for my workflow with a different timestamp (e.g. XYZfile_20171231, XYZfile_20180131, etc.). I want Alteryx to pick up the file with the latest timestamp to run the workflow. 

I checked dynamic input, but does not look very positive.

Any suggestions?

Thank you so much.

cmcclellan

Hi Wen,

This is how I did it ... 

- Directory tool (to get all files in the same directory, you can also filter by file type)

- Sort tool - CreationTime descending

- Sample tool - First 1 record (you now have the latest file in the directory)

- Dynamic Input tool - Read a list of Data Sources from FullPath, action is Change Entire File Path

You also have to set the template in Dynamic Input, but it should work fine