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 built a workflow that creates rows of data, which I want to export to several separate excel files. For this, I generated a Field "File Address" that contains the full path (FilePath) where I want to save my grouped data.
Important information : some of the FilePath drive to the same excel file, but with different sheet names.
I can easily generate my Excel files with the Output Tool, with workbooks and worksheets with the right names and in the right folders.
However, I would like to give a basic format to these recorded files: • HEADER in bold, colored. • If possible, but not mandatory, Columns with optimized widths
I tried many things, via the Table tool and Render Tool but without success. I still have this error: "Error: x64 Designer: x64 Designer: InboundNamedPipe :: ReadFile: Not enough bytes read. The communication channel has been closed. "
I think that this comes from the generation of different sheets at the same time, in the same file.
You will find attached my simplified data and workflow.
Is it possible to render different sheets in the same file with the render tool ?
In the Table tool, group by the fields that contain the sheet names and the file names. In the Layout tool, select "Each Group of Methods" as your Layout Mode, group by both the sheet and file names again, and set Orientation to "Vertical with Section Breaks". If you want to re-name the tabs in the excel file, change Section Name to whatever field has the tab names. In the Report Text tool, select that you want to "Attach text to existing field" and select the "Layout" field. Insert/format fields and/or text to your liking in the text box. In the Render tool, select to "Group Data Into Separate Reports" with a Separator of "Insert Section Breaks Between Records".
You'll need to play around until the formatting is how you need it, but this should get you pretty close.
I have managed to achieve my request using table, formula and Render tool, I have attached the sample workflow for your reference.
There will be a demerit in render tool to achieve these kind of requests.
We cannot insert new tab into the existing excel output using render tool for that we have to use Layout, but while we use render tool it takes standard width for all the tables in all tabs.
For eg., Lets consider I have a three tab called A, B and C. A tab has 2 columns, B tab has 3 columns and C tab is summary table (kind of pivot). I am fixing total table width for table A is 4inch, B is 6inch and C is 3 inch, but it seems like the render output takes its paper size and realigning table fields so the width for all the tables will be same in all the tabs.
You can format all the columns as per your requirement only concern here is total table width.
This is based on my experience with render tool, please advice otherwise.