Output multiple files to different excel tabs

Hi! Is there a reasonable way to export mutliple Alteryx outputs into the same excel file under different tabs? I found this explanation (http://community.alteryx.com/Data-Blending/In-Out/Output-different-files-to-multiple-tabs-in-an-Excel-file-v1) but it doesn't work for me (Plus even if it did I really don't like the "table" function because I loose all my decimal points and have to go in one by one to my 60 fields and change it to include multiple decimal points). Any thoughts?

Output

Accepted answers

All comments

ChadM

Hello!

We actually have another module in the community that demonstrates how to do this using the Output Data Tool:

http://community.alteryx.com/AlteryxArticle?id=kA0E00000000Vy7KAE

This method will use the "Change File/Table Name" functionality within the Output Data Tool to update and output to individual Excel tabs under the same workbook.

Thanks!

alexandramannerings

I don't think I was clear enough in my question-- I want to be able to to have TWO different data sources go into teh same excel file, each under their own tab. Does that make sense? So, I have a fork in my Alteryx stream, and currently have two different outputs, which right now have to go into two different excel documents. I want them to go into the same excel document, but with different sheets. The data are in different structures, with different fields, etc. The example you shared has data from a single stream being divided by a variable field.

Ned

This shouldn't be an issue. You will need a BlockUntilDone tool in front of each output tool to make sure its not trying to write both ata once.

jmoney

So, if I have multiple inputs and union them together then split them on the common field, I get each group in a tab, but it forces every tab to the same layout. I had a process in Alteryx 8.6 where for each file stream i used the table tool and grouped on my common field, then a layout tool that grouped each set of records on my common field with orientation Vertical with section breaks. I unioned all of my Layout outputs together and then used the render tool and output to a file. it would then create an excel file with multiple tabs and the tabs would be named based on my common field. In the version 9, the file still creates the distinct tabs but now it has generic names sheet1, sheet2, etc.

I need to retain the unique layouts for each file and name each of the tabs based on my common field. Any thoughts?

MikeN

Hi @jmoney - I think this should help you...(just change the output to point to your own drive)

OutputtoDifferentTabs.yxmd

gurujo

I've tried just changing the worksheet name, it worked for me , its giving output file different sheets

MatthieuArzel

Thanks you. This concurential writing has bothering me for hours !

asaradha

When we use the tool Block until done, is it possible for me to drop more than 3 sheets??? because, the Tool shows only 3 anchors.

daniellefzimmerman

Thank you! The solution worked perfectly!

pravinp33

while doing this, an we keep the consolidated original data in sheet1 and name it as 'Summary'

iwilliams

You could use multiple output tools and specify the same file and location in each tool, then query the sheet name for each individual tool.

Ex:

\Desktop\book1.xlsx|||first_sheet

\Desktop\book1.xlsx|||second_sheet

\Desktop\book1.xlsx|||third_sheet

...

ssink

I want to do this in an app i'm building. How do I prevent Alteryx from providing the first single tab output from generating? I only want the workflow to spit out the excel workbook that has the tabs combined into the same workbook.

Gina2021

@ssink do you have one output per tab, or multiple tables per tab?

fengying

I uploaded an excel file into Alteryx with a few different sheets and wanted to export each specified sheet into one report or separate reports. But I was not able to do that. The window showed up below. Once I pressed OK, it did not save anywhere. I need help on finding the final report(s). TIA!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703