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