2 output from 1 workflow in 2 different sheet of same excel output

[ilovecoding]

My input file is one, however i am getting 2 different output or more depending on my selection. But i need all output in one excel tab/sheet wise. Is that doable in alteryx?

[mceleavey]

Hi @ilovecoding ,

Yes.

If you would like us to help with your specific example can you post some mock data representing your input(s) and the required outcome?

M.

[ilovecoding]

Hypothetical example, the below 2 output i need in sheet1 and sheet2 of same excel output file. 

[binuacs · Accepted solution]

@ilovecoding This can be achieved by using either block until done tool or based on a column in the input file, below post has the two approaches mentioned 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-write-to-different-tab-...

[mceleavey · Accepted solution]

@ilovecoding ,

ok, you simply need to build the dynamic fullpath including the sheet names and then change the config of your output tool.

In the attached example I've built the following:

So you now have a fullpath with the tab names.

Then configure the output tool as follows:

I hope this helps,

M.