Output multiple files to different excel tabs

[alexandramannerings]

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-Exce...) 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?

[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.

[mceleavey]

Hi @Emanuelis ,

I put together a basic macro that I think does what you need.

You'll need to input your file paths etc.

The workflow takes four streams, representing disparate data sources, which are then given a source identifier and merged into one stream. They are then given fullpath fields and fed into an iterative macro:

The macro simply iterates through each instance and outputs to the dynamically created fullpath which includes a sheet variable:

Really simple, but does the trick.

Let me know if this helps.

M.

M.

[Jocelyn1]

I can't import the workflow due to different version TT

[Ris007]

Hi @MikeN - Thanks this is working fine BUT when I am trying to use this in the Alteryx Application it is only showing one tab Output file.  

[daniellefzimmerman]

Thank you! The solution worked perfectly!

[etim]

Thank you it helped !

[pravinp33]

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

[Gina2021]

Hi @mceleavey , Thanks for posting here. I see it's over a year old, but I'd love to see the macro config and it's coming in as a black question mark with the package that I cant't open.  Do you happen to remember how it worked? I just reviewed my first iterative macro example, so I'm a kindergardener. Thanks!