Solved! Go to Solution.
Can you attach sample data file with few records ?
Hi @alexlyle,
Your example works as expected, please see below for reference.
You may want to cleanup additional/unwanted quotes using Replace Function.
If you're still facing this issue, can you please share a simple input file with some records?
Thanks,
Rafal
#Excuse me, do you speak Alteryx?
Hi @alexlyle
Have you tried changing option #9 on the import options?
Tried this out, set it to None, and it worked. You'll need to do some clean up afterwards, but hopefully this works.
Let me know if it helps!
Cheers,
Esther
If it is throwing an import error try setting Option 5 to \0 to remove all delimiters. From there you should be able to remove the quotes.
Thanks so much. This fixed my issue.