We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks
SOLVED

Beginner Question: Output two data tables to the same excel worksheet

Siharmer
6 - Meteoroid

Hi,

 

Am new to Alteryx and the community so hopefully this is not too much of a newbie question. I am building a simple work flow and trying to get alteryx to write data to specific cells in an excel template. Essentially I have two countries data and each country has a separate tab in the workbook. see below:

 

The workflow works when I only output the first branch or second branch to the excel workbook ie. delete the output at the end for one of the branches but once I put both outputs in it says excel is already in use (I assume because alteryx is writing to it on the other branch).

 

Any idea how I can get multiple tables to write to the same file at the same time?

 

image.png

 

 

Any help would be greatly appreciated!

 

Thanks
Simon

1 REPLY 1
Siharmer
6 - Meteoroid

Looks like I have managed to self-solve. I used the Block Until Done item and this has solved my issue.

 

 

image.png

 

 

 

Thanks

Simon 

Labels
Top Solution Authors