Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Cant get Alteryx to render to 2 tabs in excel

craigja
8 - Asteroid

Dont know what Im doing wrong - I have 2 basic tables as well as a tab field which is either matched or unmatched, in the layout tool I group by the tab field but when I try to open the file I get an error saying Excel cant open the file.  I do see this warning in the messages window, Im not sure if this is the cause of my problems?

 

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

 

 

craigja_4-1618942938153.png

 

Basic Table config

craigja_0-1618942849573.png

Layout Confg

craigja_1-1618942881114.png

Render config

craigja_2-1618942896899.png

 

Excel Error

craigja_3-1618942922256.png

 

2 REPLIES 2
apathetichell
18 - Pollux

Question - what happens when you switch from 8 1/2 by 11 to 8 1/2 by 14?

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Urgent-Alteryx-incorrectly-truncate-da...

 

Seems to say the problem is most likely that you are trying to fit too much information on a standard 81/2 by 11 sheet of paper - if it fits on legal that would be great and you won't need to try a 50 by 50 page - but if it doesn't fit on legal - give that a try.

craigja
8 - Asteroid

Had to make it more than 50 x 50 but thats solved the error!

Labels