community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Weird Excel Headers using Reporting

Alteryx Certified Partner
Alteryx Certified Partner

Absolutely agree with you Chris, but no matter how many times you think it (and tell it to the user / customer), it appears that the "frustrated Graphic Designer" or "Graphics Designer wannabe" we all have inside comes to life and takes control of our Excels! Forcing us to add Headers, colors, and a lot of "pretty stuff"...

 

Anyway, it was a sample, because the original data is a confidential survey analysis from a Customer, and they wanted it that way to be able to filter the results later.

Regards,

_AG_

Alteryx Certified Partner
Alteryx Certified Partner

Yes the practicalities are very different. When this is a requirement I produce one table and also (unasked) on Tableau report to show them the possibilities.

If you have a workflow which may generate different columns (more or less) and so are unable to plan for how wide of a document you may need, there is another workaround.

In the Table tool, set the sizes of the existing columns you have coming in to a fixed width.  For example, in mine I have them all set to a fixed width of 2 inches.  Then, set the options for dynamic or unknown fields also to a fixed width or 2 inches.  No more manual adjustments!

Alteryx Certified Partner

@patrick_mcauliffe 

I've tried your advice in 2018.3 and it looks not to work :-(

It looks like Render tool overwrites any width settings that come from Table tool.

 

And what is worse: it not only trims header labels, but also data. And this trimming happens at least since v 11.3.

@AnastasiaStepanova 

Yes, my solution was correct back during v9.x

Unfortunately the Community has not accepted my suggestion to help users identify solutions relevant to their version.

If you agree with it, please vote to let them know here:

https://community.alteryx.com/t5/Improve-the-Community-Experience/Version-Number-in-Signature-or-Hea...

 

Meteor

I'm working on a build that renders as .xlsx as well. I'm rendering this rather than using and output data tool because I need hyperlinked text within a certain field. Due to rather large number of columns I changed the Render Configuration to Paper size B3 and orientation Landscape. This solved the truncated data issue for me. 

render configuration 2018-11-14_10-36-13.jpg

I'm still experiencing an error with the hyperlinked field.  Here is my Report Text tool configuration:

report text2018-11-14_10-44-18.jpg

I'm not receiving any errors or warnings after running the workflow, but when I try to open the rendered excel file I'm getting this message:

Microsoft Excel error 2018-11-14_10-46-46.jpg

If I remove the hyperlink field the file is created and can be opened without issue. Any thoughts?

 

Labels