Greetings,
Anyone know how to handle the re-sizing of columns that occurs when rendering tables with varying schemas to Excel File with one table per tab. Regardless of the settings I pick while using the layout tools, or tables tool the defined "width" appears to be overridden based on the page setup defined in the Rendering tool.
For example:
Table A:
| Test ID | Result | Record Count |
| 1 | Pass | 1072 |
| 2 | Pass | 1067 |
| 2 | Fail | 5 |
Table B:
| Test ID | Record ID | Source Value | Target Value | Difference |
| 2 | 15 | 100 | 95 | 5 |
| 2 | 19 | 115 | 100 | 15 |
| 2 | 25 | 57 | 55 | 2 |
| 2 | 57 | 85 | 60 | 25 |
| 2 | 101 | 64 | 68 | -4 |
When I use the browse tool after the table tools for the creation of Table A and Table B things look as desired. I use a formula tool to provide a value that will later be used as the tab name for each table. Next, I use a union tool, then a layout tool to group by Tab Name and use the vertical sectioning feature so each table has it's own tab in an excel output. However, when I use the render tool depending on the page size selected both tables are resized to the width of the larger table. This overrides my settings defined in the layout tool or table tool where I have attempted to define fixed, automatic or percentage based sizing.
Unfortunately, not able to upload workflows per company policy.
