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