This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am receiving the message above when I try to write my output to a .csv file. I have some fields that are longer that are not giving me an error when they are loaded into the file so I am not sure what the issue is here.
Here is what I have tried -
I used a select statement and tried to increase the length of the fields.
I used autofield to set the length of the fields
I cleansed the field and removed extra white space, carriage returns, etc. to no avail.
Are you getting a warning or an actual error? In the case of special characters like em and en dashes, Alteryx will throw a warning but will automatically convert to a hyphen for you. For anything Alteryx doesn't catch, you can always use REPLACECHAR in a formula before exporting to the .csv file.
I attached a screen shot to the original post, but, I can't tell what the funky characters are in order to remove them.
I tried the data cleansing tool to remove spaces (that is why there are no spaces in the text above). Tried to remove punctuation, but that did not work. I am not sure how to get rid of the warning. I will see if I can work with the regex or formula tool tomorrow to see if I can clean the comments up.
Another option for resolving this issue is check the Code Page on the configuration section of the Output Data tool. In my case, the default Code Page was set to ISO 8859-1 Latin I. When I changed it to Unicode UTF-8, the errors were resolved.