Alteryx Designer Desktop Discussions

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

Download Tool - FTP only downloading the first row of the file

tradewebes
5 - Atom

I'm using a Download tool to download a CSV file from an FTP server and am experiencing the following errors: 

 

  • When I select the option to import as a string field, it only brings in the first row of data (importing as a blob and converting yields the same results).
  • When I import into a temp file, since my file doesn't have headers, it uses the first row as headers and the Dynamic Input tool doesn't have an option to not use the first row as headers.

Is there a workaround for either of these issues?

 

Thanks!

 

4 REPLIES 4
apathetichell
19 - Altair

This sounds like the your file on your ftp server only has headers. If this is not the case -> you should see your data either when you save it to s a specific file - or to a field in your workflow. I wouldn't use dynamic input -> I'd use a batch macro and then read in the file - but it's kind of moot here - this just sounds like your file is empty sans headers.

tradewebes
5 - Atom

Thanks for the response. The file has multiple rows -- I can confirm this because I see multiple rows when I use a temporary file in the Download tool to bring the data in. Only when I store the downloaded data in a string field is it limited to a single row.

apathetichell
19 - Altair

are you seeing it in browse or the results window? do you notice odd characters or messages which say 'this contains new line' or something?

let's try this...

 

attach a text to column tool.

set up your text to column tool to split your download data by /n -> split to rows.

do you still see only one row?

 

 

apathetichell
19 - Altair

@tradewebes- did you have a chance to check on this -> and if my hypothesis was correct - can you mark my answer as a solution?

Labels
Top Solution Authors