Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

ftp from mainframe without use of batch


using windows to a mainframe, it's a simple ftp:


ftp bob





get `mainframefile` daily.txt


but i can't figure out, without the use of a batch file, to set the type=ascii, in the download tool.  ideas please?




becki kain



someone here knew what it was.  stuff a formula tool infront of the download but after the input tool and do this:




where the %2e are . in the file name.  give that a column name and tell download to use that column name for the connection.  


I am am also trying to use the download tool to FTP file down from mainframe. However, type=a directive seems to be ignored. File gets FTPed down encoded in EBCIDIC, with all line feeds stripped out. I can then read the file back in using an Input Data tool with Code Page set to "IBM EBCIDIC - U.S./Canada". That solves the encoding problem ( content is *kind of* readable) , however, everything is on one line.


This is what I have in the URL field.'PRACTICE.T.SOMEFILE';type=a


My raw mainframe file looks like this : 


row 1: my test file
row 2: my test file
row 3: my test file


It gets FTPed down looking like this : 




When I read it in using code page of "IBM EBCIDIC - U.S./Canada" it looks like this : 


row 1: my test filerow 2: my test filerow 3: my test file


Any ideas on how I can resolve this?


Appreciate the help!



Hi Becki,

Glad to know that you are from Ford too. I've been facing this issue of connecting to Mainframes through Alteryx

Thanks for you post . I tried it However it says "remote file not found" , While the file is actually present in Mainframe.


Hence could you share/attach the Workflow which you used to connect Mainframe Fac and able to download the file..


Kindly remove your RACF ID and Passwords in the download tool before you share them.




send email to you may not have access to that file.


Becki - how did you get around the issue of missing carriage return ( described in my prior note )? Thanks!


Please PM me.