Excel to CSV Conversion then Upload to FTP site

[Jay2022]

Hi,

I'm trying to convert an Excel file to CSV then upload it directly to an FTP/SFTP site/folder. I can get the file to convert but having trouble uploading it to the FTP site as the flow just keep running. Not sure what I am missing of if I have the right tools in the flow.

Thank you

[geraldo]

@Jay2022 

Try using the block until done tool.
- output to macro that converts files to csv
- output 1 to the ftp macro

[Jay2022]

Thank you Geraldo! However, the flow is still running for a long period of time with your added suggestions.

[geraldo]

@Jay2022 

As the macros did not come attached, it was not possible to analyze which tools you are using to make the ftp.
Are you using the download tool with the payload configured as PUT?

[Jay2022]

yes, I  have it set to " PUT" when I use the download tool. Then the flow fails because it is asking for Blob which I do not have. In this case I want to upload the newly converted 'csv' file into the FTP. 

[geraldo]

@Jay2022 

How is the basic configuration?

[Jay2022]

[geraldo]

@Jay2022 

check this link

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Upload-to-SFTP-FTP/ta-p/208...