Input tool reading CSV line breaks as new line

jt98

Hi all,

Im importing csv files into Alteryx which is delimited by , and ignoring quotes. However the input tool breaks the data into a new line whenever it detects a line break within one data " " itself.

Is there any way to solve this without it breaking it into a new line? I want them to be delimited properly. Attached an example of my issue.

DataA cleansing.yxmd

DataA.csv

JosephSerpis

Hi @jt98 if you tick on the option for "Allow newlines in quoted field" it should resolve most of your issue you may need to use a Data Cleanse tool to deal with some remaining trialing white space.