We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Data truncated from specific row onwards (Render)

JudithZonder
6 - Meteoroid

Good afternoon,

 

I'm trying to export my data to an excel file, but from row 14001 onwards Alteryx truncated the data, see below screenshot.

I've tried to changed the layout for the table to big number (100x100), but that doesn't seem to help.

 

JudithZonder_0-1644854324035.png

 

I hope anybody can help me out on this one?

 

4 REPLIES 4
Ben_H
11 - Bolide

Hi @JudithZonder,

 

That's really odd!

 

The truncation on the middle column is particularly strange, each individual word is truncated - Are you sure the input data isn't the issue?

 

Regards,

 

Ben

JudithZonder
6 - Meteoroid

Hi @Ben_H,

 

Yes I'm sure that's not the problem, because when looking in the data in Alteryx, it contains all the data:

 

JudithZonder_0-1644855705846.png

 

I think the problem lies within the columns 'Combination' and 'Account name', because if I remove those two from the table, Alteryx gives no error. But I still want the two columns in my output table..

 

apathetichell
20 - Arcturus

three questions -

 

1) is this from one table tool - or two or more combined using nested table or union/summarize.

 

2) (the usual render fix) what happens when you increase the size of the page you are rendering to? That is the usual culprit for this value truncation - but this does look odd - even for that.

 

3) can you attach a browse tool pre-render and and attach a screen grab of how this looks in the datastream?

JudithZonder
6 - Meteoroid

Hi @apathetichell,

 

The table is from an excel output with multiple tabs, where I used the union tool to combine the tables.

 

I've already tried to increase the size of he page, but that didn't work unfortunately.

 

In the meantime, I have done something that made the table looks even worse.. For now I just use the Output data tool, instead of Render and that seems to work.


Thanks for your response though :)

Labels
Top Solution Authors