Issue with SFTP Transfer

[AlterIT]

I am trying to transfer do an SFTP transfer using Alteryx. I am referring following article to do this (It basically convert my source file into chunks of Blob files and using Download tool it transfer the file into destination). However when I transfer the files I can see only one file in the Target even though it created 3 files out of Blob input tool. Since my original file is around 3 GB I am splitting Blob into chunks of 1GB each. After running the workflow I can see only last chunk in the Target. 

Not exactly sure what I am missing from transferring the entire file into Target or at least I am not able to see 3 chunks I am transferring .

Here is the Article I am referring to implement this: (I am referring to method 1)

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Upload-to-SFTP-FTP/tac-p/792000#M66...

Some screenshots:

Overall Workflow:

Blob Input Tool:

Download Tool (Basic Tab):

Download Tool (Payload Tab)

[fmvizcaino]

Hi @AlterIT ,

It seems you configured everything as it should. The only thing I can think of is related to your SFTP filenames, it can't have all the same name.

Best,

Fernando Vizcaino

[AlterIT]

Interesting insight, my only concern is how can I name each chunks into unique names. Will this option in Download tool could work ? Right now I am using the option Output > String , Not sure how can I get this implemented into multiple files.

Download Tool:

Here is how my Address field looks in the Text Input Tool

[BrandonB]

Might be worth leveraging a record ID tool followed by a formula to make a unique file name that increments

[AlterIT]

That sounds a solution, Any examples would be helpful 

[fmvizcaino]

Hi @AlterIT ,

Here is a suggestion for you. 

Note that you can replace your filename column, but be aware of the column size to not truncate your new path.

This will create 3 files on your ftp server that needs to be combined into a single one later.

Best,

Fernando Vizcaino