Output auto width

[Uzi]

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

[atcodedog05 · Accepted solution]

Hi @Uzi 

What you are asking needs to fixed at 2 places.

Table Tool and Render Tool.

There is no option for automatic resize you would have to set size yourself.

In table tool select and you give a width like below. This column width

Second thing would be Table width in render tool. You can set table width in render tool.

Hope this helps 🙂

[Uzi]

hmm ok is there also a way to wrap the text? 

[atcodedog05]

@Uzi 

Sorry Nope. Wrap text is excel feature 😅

[atcodedog05]

@Uzi 

Sorry i take it back.

Alteryx by default does wrap text when outputs.

Excel output:

[Uzi]

Awesome thank you

[atcodedog05]

Happy to help 🙂 @Uzi 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂

[Uzi]

ok wait got a problem 😄 

I used before the output data tool and I could give the output group by the name in different sheets... how can i do that with the two tools you mentioned  

[atcodedog05]

Hi @Uzi 

You can use layout tool for that.

Use the below config. Sheet Name is the sheet you want to give.

[atcodedog05]

Output:

I have changed SheetName to MySheet