Can't change column width when Unioning two tables and then Rendering

Question

I have two Basic Tables that I am Unioning so that I can ultimately output them to separate worksheets, using and added field called "Sheetname". The two tables pull from the same data source, however, one of the tables uses a "Cross Tab" tool to sum a few columns and create a kind of Summary worksheet, while the other table just basically reports the underlying details. Since I used the "Cross Tab" tool, the two tables have different structures (different columns). Whenever I do this, I seem to run into the issue that I cannot change the column widths. My summary table has only 4 columns, while my detailed table has 15, so when the tables get outputted to the workbook, the tables have the same width, but I cannot reduce it on my summary table (ATTACHED SIMPLIFIED WORKFLOW).

Any guidance on how to manipulate the widths would be much appreciated. If I have to use a different method of exporting to different worksheets, that is fine too, I just need some capability to update the formatting (color, add dollar signs, etc.), which includes modifying the width length.

Thanks so much,

Adam

Multi Table Union Unable to Edit Column Width.yxmd

DavidP · Accepted Answer

Ok, I've adapted your workflow a bit - have a look at the attached. The problem is not the width of the columns, it's that fact that the render tool renders every tab to a page size which is specified in the render tool at the bottom. So it will make all tabs the same width, like pages of a report.

To get around this, you can add empty space blocks either side of something you want to make smaller, such as your summary report. You can adjust the widths in the layout tool.

I also changed the Sheet headers.

Please let me know if this does what you want.