Exporting to multiple tabs in one excel from different datasets in a workflow

Question

Hi everyone, I am working on a large excel automation project and have all of my workflows in order, I can also export to my template and save as a new file. The problem I am running into is that when I pull from another set of a data inside my workflow I cannot get the data to post. I assume it has something to do with when they run and save over each other.  I have tried introducing a block until done to connect the data, but I get errors. Anyone have a good solution on how to do this? The picture attached is the end of both of my datasets!

image.png

rzdodson · Answer

@CGadbury thanks for posting the above so quickly!

I would double check your Output tool configurations to ensure they are appending data to the output if they are various data sets are going to the exact same location. If they are set up to overwrite, what will occur is that the result from Output 2 will completely overwrite Output 1 and are likely a primary cause for what you are experiencing with both output sets not displaying in the final product.

Another option to consider pertains to your Alteryx version. In the most recent Alteryx versions, they introduced Control Containers which will allow you to functionally sequence sections of your workflow without the need for additional Block Until Done tools.

CGadbury · Answer

@rzdodson If I run them separately it works, the problem is that when I run them together, they access the same file. Which is causing them to save over each other and not post data in one tab.

So, I need a way for them to run after each other, and when I have tried block until done, I start to get errors. I am thinking about using containers, but I would have to get rid of block until done and that wouldn't allow to me use blobs

Workflow.png

rzdodson · Answer

@CGadbury if able, can you post the workflow file you are working from and/or detail where the workflow is failing out for you (i.e. which Output tool)? From your initial screenshot, there isn't anything that would stand out as the primary reason the workflow may be failing.