Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Alteryx Formatting - Wrap Text

mharley001
5 - Atom

Hello! 

 

One of the columns in my Alteryx output includes a full address: Name, Street Address, City, State, Zip 

 

The model is currently bringing all the information into one line like this: 

ARIZONA DEPARTMENT OF REVENUEP.O. BOX 52153PHOENIX, AZ 85072-2153

 

But I would like to get the model to wrap the text in the output like this:  

ARIZONA DEPARTMENT OF REVENUE

P.O. BOX 52153

PHOENIX, AZ 85072-2153

 

Is there a way to get the text to wrap?  Hoping someone has a solution! 

 

Thanks! 

 

3 REPLIES 3
ponraj
13 - Pulsar

Here is the sample workflow.  Steps to wrap the text as below.  Hope this is helpful. 

 

1. Open the excel output of this workflow. 

2. Select all the column and select autofit column width under format 

3. Now select the column which you would like to wrap and then click wrap text

 

Wrap text.PNG

 

mharley001
5 - Atom

I think that does it! 

 

Thank you! 

Teddy
5 - Atom

Can we have alteryx perform this function you described?

Labels