Error opening path filename: no fields found csv file

[TomCurran]

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.

[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.

[ddiesel]

@TomCurran

I have a similar issue when inputting files from our FTP drive. My workaround is to input the file with no delimiters, then parse in a second step with a text to columns tool.

Hope that helps.

[TomCurran · Accepted solution]

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.

[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.