Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Wrap Text

Highlighted
5 - Atom

How can I get the header on a table to wrap text for consistency. I have a flow that spits out a PDF of table that includes "vs LY," "vs Plan," and "vs Fcst" (forecast). sometimes the vs Plan will wrap and stack the words, sometimes it doesn't. How can I make these always automatically stack to be...

 

"vs

LY"

 

"vs

Plan"

 

"vs

Fcst"       

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @KevinAres 

 

There is a tricky way to do this by modifying the raw PCXML/Layout field text. In this solution, I rely on the pattern that any time there's a "vs " in a field, you'd like the "vs" to be on the first line and the rest to be on the second. In the attached workflow, I start with a Dynamic Rename tool with the following expression:

 

Replace([_CurrentField_],"vs ","vs<br />")

 

The PCXML/Layout format generally contains HTML formatting where "<br />" is the marker for a line break. The next step is to leave this marker in place while the Table tool is used as normal. The tricky part is that once the Table tool creates that Layout field, we edit the table field text with a Formula tool to replace that line break with a not XML-escaped version. This modified text is then formatted back into a Layout field using a Report Text tool in Expert mode (which allows us to inject this raw PCXML text).

 

20200214-RenderNewline.png

 

 

 

 

 

Check out the attached workflow to see this in action.

Labels