Embedded Newlines in CSV Format

[PeterAP]

Does anyone how you can output a dataset from Alteryx to CSV which has embedded newlines in it? I don't want to remove the newlines from the field itself.

I.e. with out the newlines, in my output I get the following:

DESCRIPTION1 DESCRIPTION2 DESCRIPTION3

But I want to get:

DESCRIPTION1

DESCRIPTION2

DESCRIPTION3

Thanks!

[echuong1 · Accepted solution]

You can concatenate the values together and use "\n" as the delimiter, which stands for new line.

[danilang]

Hi @PeterAP 

Since your data already has the newlines in it, you can just output to a csv.  Your output file(with an extra ID field) will look like this

Concat_Field1,ID
"DESCRIPTION1
DESCRIPTION2
DESCRIPTION3",1

You should be aware of the warning given by Alteryx about the newlines in the data 

The embedded new line may cause errors when you try to load the file into 3rd party apps.  It opens in Alteryx and Excel with no issues, but some other programs may split the file into records on the newline before parsing, causing incorrect results

Dan  

[PeterAP]

Thanks @echuong1, I had concatenated in a different way using the multi-row formula tool, but I think your method is best.

I think the problem I was having was actually due to the way in which Power BI was reading it in rather than the Alteryx Output. However in the PBI data source settings I was able to change the options to "Apply all line breaks" and it worked.