CSVFile: A field was missing a closing quote in record 1

Question

Hi all,

I am using a run command tool to output to a csv file. However, I am getting an error that "A field was missing closing quotes". It looks like run command tool worked in the sense that it actually wrote to the csv file I wanted but the workflow error and prevents data from going through. Any reason as to why this is happening?

BretCarr · Answer

Are you able to get the data in the output of the tool before you try to make a file?

rafalolbert · Answer

Hi @jaipersr,

It looks like some special characters might be breaking your logic.

You could use a Formula tool or Multi-Field Formula (and do it for all fields in your schema) as a penultimate step of your workflow and wrap all fields in a single or double quote.

You may also want to check the presence of some additional characters if the above doesn't resolve it for you and escape them proactively - best to try with sample data first and open for full data frame later.

Hope you'll manage to resolve it quickly, let me know how you get on?

Thanks,

Rafal

#Excuse me, do you speak Alteryx?

jaipersr · Answer

I am using a run command tool. Not an input tool so I do see that option interface to do that.