Dynamically upload file to server with datetimeformat as the file type

[kmoon]

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.

[RishiK]

Hi there

Have a look at this link

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

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

[kmoon]

Hi @RishiK ,

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.