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.
Solved! Go to Solution.
Hi, @DQAUDIT
Sure thing, you shouldn't load company workflows.
What you might consider, however, is generating a similar workflow from sample files so that we can see the issue and offer treatments!
The better the question set up, the better (and faster) your @AlteryxCommunity solution approaches.
In the meantime, please check out the link below (I believe that the mechanics of that post will work for you).
If it works for you, please mark as a solution or like, so that others running into similar scenarios can leverage as well.
Cheers!
Hi @RobertOdera ,
Thank you for the feedback. Unfortunately, that's the issue. My company has strict policies about uploading any type of attachments whether real, sample, or personal. That's why I provided the sample data showing varying schemas.
I appreciate the help.
Sure thing, @DQAUDIT
Below is what I came up with based on the schemas.
Yes, I see what you mean (columns A-C in table A and columns A-E in table B total the same width).
Perhaps we should up vote a small enhancement in the Ideas section?
The workflow and excel output are attached.
Cheers!