Export to two different tabs of the same excel file

[hegdepavithra10]

Is there a way to export the output of the same workflow to two different tabs of the excel file alteryx?

PS: Would appreciate if the solution snippets were pasted as i am out of my trial version of alteryx

[hegdepavithra10]

Hi, @atcodedog05 

My data is not as it is in the example.

1. select tool -> table tool ->layout-> render tool

2. group of formulas -> select -> output tool

These cannot be joined or brought together. For the output of these , i am trying export 1 in Sheet 1 and 2 in Sheet 2 of the same excel.

[hegdepavithra10]

Hi @atcodedog05 

Also my data is something similar to this what @messi007  had provided

I have tried this and does not seem to be working. Also i do not understand why does the output of first "block until done" is render tool and output tool?

[atcodedog05]

Hi @hegdepavithra10 

It should still work.

Guessing your outputs will be like this

Check that your Output Tool is not configured to overwrite file.

Check and let me know.

[atcodedog05]

Hi @hegdepavithra10 

1,2,3 of block until done is sequencing of execution.

Render Tool should be executed First and then 2nd Output Tool.

Check my previous explanation it should be at the end of page 2 of this post.

[atcodedog05]

Hi @hegdepavithra10 

As discussed this is what you can do. The workflow is detailed with steps.

Workflow:

As you can see Render flow is longer yet since block until done was used at a common. Render flow got executed first.

Please check and let me know🙂