Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Weird Excel Headers using Reporting

Highlighted
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_

Highlighted
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.

Highlighted
14 - Magnetar
14 - Magnetar

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!

Highlighted
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.

Highlighted
14 - Magnetar
14 - Magnetar

@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...

 

Highlighted
7 - 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?

 

Highlighted
5 - Atom

this worked for me! I changed output from A4 to A3 in the render tool and it worked.

Highlighted
8 - Asteroid

I am also able to "fix" the truncated headers and data by making the paper size wider. But, I would like to not have the columns so wide and just have the smaller columns in excel with the headers and data wrapped. It still seems like a bug that the headers and data are truncated, is there a plan to fix this? I also do not get a warning when running the workflow that there is truncation happening, so if I hadn't looked at my output first there is no indication of lost data.

Labels