Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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
Top Solution Authors