render a table into excel - incorrectly truncated data

Hi,

I am having trouble render a table into excel. The Table output looks fine in the Browse Tool but when I render it to Excel I get the following warning. The excel file that is generated is of no use.

Warning: Render (9): The current page layout will cause some data to be incorrectly truncated. You may consider modifying how the data is laid out.

I can't figure out how to modify the data layout to get all the data to come through to the excel file.

Output

Accepted answers

LordNeilLord

Hey @ChrisB_dup_72

Here's a few things to try....in your table tool set the Table Width to Automatic..

And in the Render tool set your paper size to custom and the size to something like 50 x 50 (you want to play around with these sizes to get a good fit)

Renderxls.yxzp

All comments

LordNeilLord

Hey @ChrisB_dup_72

Here's a few things to try....in your table tool set the Table Width to Automatic..

And in the Render tool set your paper size to custom and the size to something like 50 x 50 (you want to play around with these sizes to get a good fit)

Renderxls.yxzp

ChrisB_dup_72

That worked. Thank you very much!

Pat360

Hello -
Another workaround that I noticed works for me is in the Render tool, choose a Paper Size in the drop down that is slightly larger than the standard "Letter" 8.5 x 11 inches (215.9 x 279.4 mm) such as :

- A3 : 11.7 x 16.5 in (297 x 420 mm)

- B4 : 9.8 x 13.9 in (250 x 353 mm)

Render Tool.png

Note:

This needs to be done in conjunction with:

- any Basic Table tool set to "Automatic"

- the Layout tool set to "Automatic"

Output to Excel, Word & PDF:

- It's actually interesting... it's almost like by setting a wider than standard output on the Render tool, it allows for the data in the Basic Table and Layout tool to "grow into" the columns... and voila! no truncation!

- Also a HUGE BONUS, I tested the output to Excel, PDF and Word (the only three formats I tested), and it auto-formats to the page size width in both Portrait & Landscape mode!!! That means no fighting with a table with rows that spill over to multiple pages.

- Last thing, for this to work.... you should set the "Margin (in.)" in the Rebder tool to "1.0 inch". This will allow for enough space for when you actually print the page, and not have the printer cutoff your table!!

Hope this helps!

Kmassey

Thank you for this info! Not sure why it's so hard in Alteryx but this series of tools and your R&A helped me immensely.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703