This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I see that when saving a pcxml output to Excel (xlsx), some of the columns are truncated. This includes the column header, and appears to truncate the end of the value on the row not the very end of the column header name string (see the attached file, you'll see what i'm talking about). See thing across apps, and I'm pretty sure this wasn't happening before. Might be an internal company issue, but wasn't sure.
I've not seen this before - but if you are able to mock up a simple flow with some raw data (in a text input), and the method you're using to generate the output and attach to this thread, I'm happy to test this and see if we can find the problem, or replicate the issue?
Thanks for the response. See attached input file and workflow. I run it as an app and then export the pcxml results as XLSX. You will see the values truncated as described.
One thing I found is that if I only select a few columns (via Select Tool) for the output, i don't see this issue. Is there some setting in the Basic Table tool, etc. that I need to update to keep this from happening?
My company support team figured it out. it's the render output width. It expects a "normal" page size so I have to manually adjust that width output. Alteryx should probably add an option added to the software to auto-size.
Thank you for this! The Custom Sizing does not resolve the issue for any other output than the xlsx. I have 39 fields in the output so I set the custom size to a width of 60 in order for the data to look organized. PDF still tries to cram all the data into half a sheet of an 8.5x11" and the word doc just looks messy.
Also, if the end user ever wants to print the xlsx data, they'd need to go into Page Layout and reset the Width and Height to "Automatic".