cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

RENDER Multiple TABLES to 1 Excel File and Name the Tabs

I have multiple TABLES that each contain different data and need to be RENDERED into 1 Excel file, each on their own tab.  You only seem to be able to do this with the OUTPUT DATA tool, but that doesn't work with formatted TABLES.  I was advised that I have to RENDER the formatted TABLES out, which doesn't allow you to name the tabs and forces each table into its own Excel file.  As some of my reports have over 30 tabs, this is not an acceptable option.  The program I currently use, which my company is eliminating, offers you the option of naming the tabs, as well as asking if you want to add them as a new tab to an existing file, replace an existing file, or export the data to a new file.

4 Comments
Meteor
While the columns would remain the same, the number of rows will vary each month, so the "range" would never be the same each month. It would really be much simpler if you had a tool similar to the JOIN tool where you link the multiple tables to the one tool, have it offer you the option of "naming" each tab (table) to be exported to 1 file, and offer the option of overwriting the current file or adding a new tab to an existing file. Thanks.
Quasar

Hi,

Just to confirm, have you tried setting up your formatted tables as Named Ranges in Excel and having the Output Data tool output to these Named Ranges?

This article gives a good example of how to do that.

 

https://community.alteryx.com/t5/Data-Preparation-Blending/Excel-Output-to-Named-Range/m-p/9644#M159...

 

Atom

Hi Tammy.  Did you ever figure out how to do this?  I am encountering the same problem.  I want to export 3 tables to the same excel workbook, and name the tabs.

Meteor
The program does not allow you to RENDER multiple tables to one file. You have to RENDER each table to its own Excel file, then create a macro in Excel that moves each separate file into 1 Excel file, rename the tabs, adjust columns widths, and add Freeze Pane lines.

I was advised that these features above are something they will consider in 2018 as part of the improvement plan they are working on for the Reporting tools.

Please consider the environment before printing this email.

E-mail messages may contain viruses, worms, or other malicious code. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective action against such code. Henry Schein is not liable for any loss or damage arising from this message.

The information in this email is confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this e-mail by anyone else is unauthorized.