Error opening path filename: no fields found csv file

I am having a strange issue with a csv that is downloaded from a SFTP server.

It is a csv file with | delimited.

If you open and save the file with Excel or Notepad Alteryx will be ok with the file, but straight from the SFTP server this is the error message:

Error opening path filename: no fields found csv file.

Test.csv

CSVfromSFTP.yxmd

Input

Accepted answers

TomCurran

I am still not quite sure what the issue with the file is, when copied from the server to my drive, but I since created a workflow that downloads the file from the server and it does recognize the file.

All comments

j_acon

You get that error message when there are no contents in the File. I had No issues opening the file you uploaded.

Maybe your file is not completed downloaded when you try to open it with Alteryx.

TomCurran

No, The file has completely download before I attempt to input

TomCurran

So another strange detail, if I download the file Test.csv from here, it works fine, it appears only directly from the SFTP to my PC does it have this error.

TomCurran

aspain

I have just had this problem and found it occured when I checked "First Row Contains Field Names" and then set "Start Data Import on Line" to > 1 in the data input tool.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703