community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Combining 2 results into 1 output with 2 tabs.

Highlighted
Asteroid

Hi There,

 

I am trying to combine 2 results into 1 output but with 2 excel tabs.  Enclosed is a picture of the workflow.  The 2 Select tools at the end of the flow is what I want to combine the file but with 2 excel tabs...Please help!

 

Thanks!

Untitled.jpg

 

Bolide
Bolide

Hi @yzhang316 

 

Two options here, both shown below and attached. One is a bit easier, but can get messy if your fields are different between tabs; the other batches through the different tabs so you get clean tables each time

 

BAtchTabs.PNG

 

 

If your tables differ, you can use option 2 which batches and removes null columns. 

Hope that helps

 

Andy

Pulsar
Pulsar

Hi @yzhang316 ,

 

You can use two separate Output Data tools, and have them write to different tabs in the same Excel file.

 

If you find this is throwing an error, put a Block Until Done tool before the first Output Data tool.

 

Let me know if this works!!

 

Cheers,

Esther

Bolide
Bolide

@yzhang316 

Note I've just updated my post above to include both options, so you can demo. Obviously choose one of the two options, no need to run both, otherwise you'll be writing it multiple times!

 

Andy 

Labels