How to prevent the Table tool from removing text?

When I try to move a dataset from a Union tool with 15 columns into the the Table tool, text and numbers get cut off. For example, a value of 3,000,000 will become "3,000,0" in the Browse tool.

I'm using the Table tool rather than the Output tool to utilize the conditional formatting inside the Table tool.

One work around I tried is changing the data font size to 3, and then changing the font size in Excel.

Are there any alternative methods to prevent numbers and text getting cut off?

Thank you!

Reporting

Accepted answers

DataNath

Hey @AlteryxUser1, you can try adjusting the paper size to make it larger and stop the results being trimmed. This is in your final render tool which will output to Excel, after the table tool.

Within the table tool itself, you may want to try and make the width larger to allow for the full values to be displayed.

All comments

DataNath

Hey @AlteryxUser1, you can try adjusting the paper size to make it larger and stop the results being trimmed. This is in your final render tool which will output to Excel, after the table tool.

Within the table tool itself, you may want to try and make the width larger to allow for the full values to be displayed.

smoskowitz

Its a problem, but on the render tool, you need to make the paper size wider. This usually prevents data from being lost.

Seth

AlteryxUser1

Thanks for pointing this out! I went to the Render tool and adjusted the paper size and it worked!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280