community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

DELETE SFTP Files

Highlighted
Meteor

So turns out the download tool can't delete files off our SFTP site.

 

Ive gotten a R script (utilizing RCurl) to run it just curious if we can get alteryx to generate the script (in formula tool) and then pass it to the R tool to run the script? 

Alteryx
Alteryx

If you already have a working script have you considered using the Run Command tool to kick this off? Also because it is already in R, have you tried using it in the R tool?

Meteor

well the process we want to do is dynamic with automation on our company gallery. 

 

Have the workflow run on a schedule where it pulls from SFTP, saves to company disk then have the workflow hit the SFTP to delete the files from the SFTP... and the idea I had was to use the formula tool to generate an R script to delete the files as the names will probably change. 

Alteryx
Alteryx

Yep, that is possible too! You can either replace the entire R script from the formula that you are referring to or just have a placeholder in your R script and check the "Replace a specific string" box down at the bottom of the configuration window and only modify that part of your script. Leveraging a macro at the end of your workflow to accomplish this sounds like the way to go. 

 

 

R tool interface.PNG

Meteoroid

Hi, would you please share the r script? Thanks.

Labels