How to Render a Table with Multiple Lines in a Cell

Hi community -

I am trying to render a table to PDF with multiple lines of text within one cell as shown in Exhibit A below. However, after several attempts and fixes, Alteryx still renders as shown in Exhibit B.

Any help would be greatly appreciated.

Exhibit A - Desired Outcome

Desired Render.JPG

Exhibit B - What Alteryx Renders

What Alteryx Renders.JPG

Report Tool Overwriting Line Breaks.yxmd

Reporting

Bug

Accepted answers

Qiu

@Zephyrus
Credits go to @patrick_digan and dont ask me how does it work 😁
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Working-with-wanted-line-breaks-and-the-Table-gt-Email-tools/m-p/129514#M20961\

Report Tool Overwriting Line Breaks.yxmd

patrick_digan

@Zephyrus Great question! Alteryx knows we're changing the html behind the scenes, and so the render tool throw errors (even though you see that it still works). You can "trick" alteryx with the attached macro that I created for this particular use case right before the render tool. It uses a report text tool to fool alteryx into thinking that your html is coming from a reporting tool.

Report Tools fix.yxmc

All comments

DawnDuong

hi @Zephyrus

Firstly, add a Summarize Tool (Group by: Movies Series, Concatenate: List of movies - with newline (\n) as separator. This should get you the desired outcome.