Alteryx Designer Desktop Discussions

ShreyaSharma · ‎04-11-2021

Hi Team,

At present, I am getting the output using the reporting tool. Now I want this output to be send to FTP server.( Upload the file)

I read lot many discussion on the page but I think non of the example are clear.. Is it people are not FTP server to upload the files .

If someone has very good understanding on the Upload to FTP Kindly reply back.

Thanks

danilang · ‎04-12-2021

Hi @ShreyaSharma

Here's an example of how to write a file using the reporting tools and then take the same file and send it an FTP server.

It relies on using the %Temp% variable so that it will work in Designer and on the Gallery. The green container processes your data and renders the output file to the temp location. The blue container starts with a Text input to hold the temp file path and the FTP url, then uses a Blob Input to read the output file as a blob so it can be sent to to the FTP s using the Download Tool. The red container handles the synchronization between generating the file at the top and then reading it back in in the bottom The combination of Block Until Done, Summarize tool and the Union will guarantee that the File is completely written to the output before it is read by the Blob Input. The Filter tool here removes that extra row that is added by the summarize tool.

The FTP URL and the user name and password in the FTP tool are dummy values, so you'll have to enter the correct values for you situation. For more information on using the Download Tool to upload to ftp sites see this post

Dan

ShreyaSharma · ‎04-12-2021

Hi @danilang

One question say for example I have multiple fields in the output so how to use this summarize .. Will it be just first field to change to count and rename the output field name or i have to do for multiple fields.