LineBreak at the end of a string not outputing to excel

[M_Lukasik]

Hi all,

I have an Excel file, which can contain LineBreaks at the end of the string (example see below).

ID	String
1	sampletext1
2	sampletext2
3	sampletext3 sampletext4

When reading the table, Alteryx recognizes the LineBreak and warns me with a red triangle in the data preview. So far so good. When I try to output the table to an Excel file, some of those LineBreaks do not pull through. To be more precise, any LineBreak, that is at the end of a string, is being forgotten (Output example see below). In that example only the Linebreak after "sampletext3" would make its way to the excel file, as the LineBreak is not at the end of the string.

ID	String
1	sampletext1
2	sampletext2
3	sampletext3 sampletext4

Did anybody ever encounter such an issue and know a fix?

Many tanks in advance and kind regards

[cjaneczko]

Have you tried concatenating the line break after the field? 

[String] + CharFromInt(10)

[M_Lukasik]

Thank you for the suggestion. I tried it out (see attached), but unfortunately the output excel file is still without LineBreak.

[Qiu]

I also tried the "Table + Render" tool and it did not work either.
It seems that the "empty" newline is removed when outputting.

[flying008]

Hi, @M_Lukasik 

Maybe you can output it as .csv file for retain the line-break.

[M_Lukasik]

Unfortunately, this didn't work either. Also, the data is being inserted into an existing excel file with multiple sheets, so this would, unfortunately, defeat the purpose.

[cjaneczko]

I downloaded your workflow and see the line breaks. This appears to be an Excel Configuration issue and not an Alteryx issue. If you are dumping this into an Excel Template. Ensure that Wrapped text is enabled and the Alignment is set to Top Align.