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?
Solved! Go to Solution.
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
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.