Data truncated from specific row onwards (Render)

Question

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.

I hope anybody can help me out on this one?

JudithZonder · Answer

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 :)

apathetichell · Answer

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 · Answer

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:

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..