Embedded Newlines in CSV Format

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!

Output

Accepted answers

echuong1

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

New Workflow1.yxmd

All comments

echuong1

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

New Workflow1.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703