community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

CSV file: a field was missing a closing quote in record 333

Highlighted
Meteor

Hello

 

I am having an issue with opening a TXT file, getting the error, below the screenshot. I am attaching a sample of the file I am trying to open. Can anyone suggest a solution?

 

Capture.PNG

Alteryx Partner

Hi @Aldona_S, you can try to read the file using as delimiter \0, then remove the indesired lines, using a text to column to split the fields, dynamic rename to give the name of the header and select to deselect fields that are not necessary. Attached an example, I hope it helps

Meteor
Spoiler
Thank you @mborriero :) Worked well
Atom

I couldn't figure out how to fix this in Alteryx, but the issue is because at the beginning of a parsed cell (after you have split your txt file) you have a hash (#) and because the end of the cell doesn't have the hash, Alteryx is giving you an error.

 

I just found the # and deleted it in my input txt file and it resolved the issue.

Labels