Alteryx Designer Desktop Discussions

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

Headers Truncated while rendering data to Table

dkma
8 - Asteroid

Hi all,

 

The Heading names are truncated, and wrapping text of Headers while rendering to Excel File, and getting warning message each time 

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

 

Ex... If the Header Name is "Date". it's displayed as "Dat"

 

How to fix this. 

 

Kindly help

dkma_0-1630648514731.png

 

10 REPLIES 10
Sebastiaandb
12 - Quasar

@dkma  Can you make a dummy? 

 

First thing i would look at is data length of the variables and look into the rendering tool. It would be really helpful to have a dummy for this to solve your riddle :-).

 

Greetings, 


Seb

dkma
8 - Asteroid

Hi @Sebastiaandb 

 

 

dkma
8 - Asteroid

I have set to decimal length in basic table tool to numeric values

dkma
8 - Asteroid

Basic Table tool

 

 

dkma_0-1630651139774.png

 

 

 

 

dkma
8 - Asteroid

Lay out tool

 

 

 

dkma_0-1630651219303.png

 

dkma
8 - Asteroid

Render tool

 

 

dkma_1-1630651300738.png

 

dkma
8 - Asteroid

output headers

dkma_1-1630651828346.png

 

 

 

atcodedog05
22 - Nova
22 - Nova

Hi @dkma 

 

My suggestion would set page layout to custom and increase the width in Render tool.

atcodedog05_0-1630651931484.png

 

Hope this helps : )

 

dkma
8 - Asteroid

for one of the iterations

 

dkma_0-1630656285086.png

 

 

Labels