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