This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
I have a workflow that creates one spreadsheet with four separate Excel tabs by using four separate instances of the table and layout tools which are combined with the union tool and outputted using one render tool.
On the render tool I have report style set to a custom size of 20 x 11 in order to compensate for one of the tabs that has 19 columns - otherwise it truncates the columns.
I have another tab with only 3 columns, but the columns are expanded out much further than needed - I'm guessing because of the render tool settings of 20 x 11.
Is there a way to change the column widths for just the tab with 3 columns? I've tried changing the Table tool Table width, as well as the Layout tool Layout configuration to different settings such as changing to fixed and percentage. But the columns are always expanded out too far. In fact the column widths don't change at all no matter how I change the configurations on the Table and Layout tools.
You're correct that once the render size is set, it's used for all sheets. What you can do to render your data in a more concise manner is add empty fields to that sheet so they can take up some of that space.
The 'Default Table Setting' button is at the bottom of the Table tool configuration window. What I was suggesting by "not visible" was to remove the cell outline and fill with a white color so those fields are less obvious.
Thanks. It works, but it makes the column really small since I cant control the width. Unless I put something in there which then will get picked up if you are in the actual cell or apply filter which then grabs that "blank" column since the text is there but not visible.