Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Render Tool - Multiple Excel Tabs with Different Widths

alexvornsand
7 - Meteor

Hi,

 

Mostly posting for visibility (as this has been addressed but not resolved in this post: https://community.alteryx.com/t5/forums/postpage/board-id/designer-discussions). I'd like to render several tabs to an Excel file using the reporting tools. I can put each of the tables on a separate tab using the 'Each Group of Records' + 'Group By' + 'Vertical with Section Breaks' + 'Section Name' options in the Layout Tool, but when I go to write the file using the Render Tool, the narrower table is stretched to the full width (set to contain the wider table).

 

In the toy example below (and attached), I'm generating a pair of tables (one narrow and one wide) for each of 10 records. Ideally, the end output would be 10 files (one for each record) with two tabs each: a tab containing the narrow data (set to an appropriate width) and another containing the wider data (wider width).

AlteryxRenderVariableWidthTabs.PNG

1 REPLY 1
RobMotiwalla
7 - Meteor

Any luck with getting this solved? I am having the same problem, and it seems like a ridiculous limitation, especially since you can choose the width in the table tool, it just gets overridden by the render tool.

Labels