Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

URL download with changing prefix

Highlighted
5 - Atom

I want to make a workflow where I have to download a CVS file from a URL where prefix changes with each day.  Filename-01022018-108.cvs, the next day will be Filename-01032018-109.cvs

Highlighted
Alteryx Partner

Is the number linked to the date in any way ?

What happens on Feb 1 ?

Is the 108 & 109 significant in any way &/or can be calculated ?

Highlighted
14 - Magnetar
14 - Magnetar

Hey @Djohnsonjr! If you save the files in the same folder, you could use the Directory tool, sort by the last write time, and only keep the most recent file (with a Sample tool). Then just use the Dynamic Input tool followed by the rest of your processing. If you would like an example workflow, please attach a sample workbook. Hope this helps!

Highlighted
5 - Atom
I have add a screen shot of what the file looks like. There is not a pattern to the -108 or -107.
Highlighted
Alteryx Partner

The number looks like it might be when the process started to create the file.  @Kenda has provided a great solution, or change the process so that the time isn't included in the filename.

Labels