Alteryx Server Discussions

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

'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live! And don't forget to check out our Digital Costume Thread to get yourself in the mood for a candy binge!

Dynamically upload file to server with datetimeformat as the file type

Highlighted
8 - Asteroid

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 destinationSo 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.

 

Highlighted
Alteryx
Alteryx

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.

Highlighted
8 - Asteroid

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.