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

Output auto width

Uzi
8 - Asteroid

Hi, 

 

is there a way to output to excel with autosize columns? The excel which comes out is just like random width... Is there a way to fix it to 100% depends on the length of the text? I tried it with the reporting tool "Layout" but it makes no sense

Uzi_0-1606816725971.png

 

13 REPLIES 13
Uzi
8 - Asteroid

Sorry maybe I didnt explain it right. 

 

I gtouped all with the same name in different sheets. For Example all "A" in one sheet, all "B" in second sheet and so on

atcodedog05
22 - Nova
22 - Nova

Hi @Uzi 

 

Ok got you need to modify the before solution little bit for it.

 

Data: I will grouping on column Sheet

atcodedog05_0-1606824995280.png

Workflow:

atcodedog05_1-1606825046568.png

 

Configuration

Table tool: set the column on groupby

atcodedog05_2-1606825075599.png

Layout tool: set the column on groupby and column as section name. Configure like below.

atcodedog05_3-1606825155514.png

Render tool: No changes

 

Output: Sheets

 

atcodedog05_0-1606825268870.png

 

Hope this helps 🙂 Feel to ask if you have any questions


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Uzi
8 - Asteroid

Awesome. Working perfect. Thank you so much mate

 

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @Uzi 

 

Cheers and Happy Analyzing 😀

 

Feel free to reach out if you face any issues 🙂

Labels