Keeping Line Breaks in the Table Tool

Hello,
I am trying to format my data for a report. I have successfully added line breaks to my data so that it appears as follows in a single cell.

Growth
(+3 units)

When I send this data to the Table tool, it comes out in one line.

Growth(+3 units)

I have tried to follow the directions provided by previous posts on this topic including this knowledge article https://knowledge.alteryx.com/index/s/article/Email-Tool-not-recognizing-newlines-in-concatenated-field

When I go to replace the the embedded new line with " ", it just embeds that text in the string. And when I attach the Formula tool to the table tool, it converts the table object to a VWString.

Any idea what I could be doing wrong or potential solutions? I am on 25.1

Reporting

Accepted answers

alexnajm

You tried the options in this thread too? Solved: Working with (wanted) line breaks and the Table > ... - Alteryx Community

All comments

OTrieger

@EB_Roy
The article that you referred to is relating to emails. Emails have 2 formats, text or xml. is xml code for break line. However this solution will not work for the Table tool.

You can try insert \n inside string expressions to add line breaks within a single cell/field.

EB_Roy

Hi @OTrieger,

Thank you for your feedback. I was already able to add line breaks to my data within a single cell. The issue is that when the data is passed to the Table tool, they are not maintained. The table tool outputs the values on a single line.

OTrieger

@EB_Roy
You did not use correctly BR, try using only without /. HTML / code is to close a code, but BR does not need to be closed. So use instead of . That should work, I did not realized that you were using the wrong HTML code

EB_Roy

Hi OTrieger,

Thank you again! However I am still having difficulty adding and maintaining these new lines in the data after the Table Tool. I have attached a simple example of what I am seeing. I appreciate any additional insights you can provide.

Embedding new lines example.yxmd

alexnajm

You tried the options in this thread too? Solved: Working with (wanted) line breaks and the Table > ... - Alteryx Community

EB_Roy

Hi Alex,
Thank you! I was combining the table with some other elements in a Layout, but if I applied the Regex Expression to the Layout column right before the Render, it worked!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703