Dynamically upload file to server with datetimeformat as the file type

Question

Hi @MattD,

I am writing data from a database and would like to upload to a server. I have attached a workflow that points out how I am writing the file to a specific location when I run.

I used "M:\Desktop\Myfile." +DateTimeFormat(DateTimeToday(),"%Y%m%d") in the formula tool to write the file in that destination. So the day I run the file, the file name is shown as Myfile.20190530 with 20190530 as the file type. In the output tool, the file format is .csv.

This works good in my local system. However, I want to upload these files to server location once in a month.What is the best way to do it dynamically?

Can I use something in the formula tool that would point to the server with authentication?

Your response would be appreciated.

Thanks.

FTP Server file with dynamic output name.yxmd

kmoon · Answer

Hi @rkapoor ,

Could you please show a demo of using a command tool or download tool to get the output? I have attached my file.

I haven't used command or download tool before.

Would appreciate.

Thanks.

FTP Server file with dynamic output name.yxmd

rkapoor · Answer

Hi there

Have a look at this link

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/FTP-Site-Upload-Download-files/td-p/398

You should be able to use the Download tool (POST / PUT) or the Run Command tool.