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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

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

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

Highlighted
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