Savings app output to Excel truncates data

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.

Anyone else ever experience this?

Thanks

app column trunc.xlsx

Apps

Accepted answers

nsmith293

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.

Thanks.

All comments

SeanAdams

Hey @nsmith293,

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?

Cheers

Sean

nsmith293

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.

out

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?

Thanks!

New Workflow4.yxwz

Test Data - FORUM.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703