Learn more about the Alteryx Maveryx Universe recently announced at Inspire 2023!

Alteryx Designer Desktop Discussions

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

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

Aldona_S
7 - 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

3 REPLIES 3
mborriero
11 - Bolide

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

Aldona_S
7 - Meteor
Spoiler
Thank you @mborriero :) Worked well
smubarik
5 - 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