Hi,
I am using alteryx to create a table and output in Excel.
The table has more then 20 columns and about 200 rows.
I am using the Basic table tool and Render tool, but the output table in excel has trimmed values for text feilds e.g. for Team its only showing T, for "England and wales" in output table is showing En a Wa.
Please can someone assist me in this issue.
Kind Regards
Solved! Go to Solution.
Is there any chance you could supply your workflow and some mock-up data that shows the behavior you're seeing?
Hi Lisa,
If you look at the last part where I have used the Render tool after the table tool and the generate a temporary file then it actually trims the names of the headings.
In this workflow, I have actually unselected half or maybe more columns just to make it readable.
Is there any way you can suggest to get the full column headings.
Regards
@ahsankhalid There is an issue with the render tool and the size when outputting to excel. There is a great thread over here where a number of folks chimed in on how to address the issue by changing the size in the render tool to something bigger.