Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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