Alteryx Designer Discussions

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

Weird Excel Headers using Reporting

Aguisande
15 - Aurora
15 - Aurora

Hi Guys (and Girls)

Today, I was presented with this case:

Using the Reporting tools (a Table & Render), when I select Excel as the destination for the report, the Header names (Field names) are chopped or renamed (in HTML for example, they came out right).

 

In this case is something like this:

Excel Headers

I'm attaching the basic workflow.

 

Any help would be appreciated.

Thanks in advance

18 REPLIES 18
Aguisande
15 - Aurora
15 - Aurora

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_

chris_love
12 - Quasar

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.

patrick_mcauliffe
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!

AnastasiaStepanova
6 - Meteoroid

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

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

 

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

 

farahb001
5 - Atom

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

phoebe_kelley
9 - Comet

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.

hellyars
12 - Quasar

@chris_love  I agree, but tell that to my client.  The archaic Render Tool is the only way I can format the Excel to replicate the report my client wants -- dozens of formatted tables per worksheet.    

Labels