Output results to different sheets

[murrayjl03]

Hi,

I am looking to display some columns a Sheet1 of an excel file and some other columns in Sheet2. 

Is there any way of defining which fields appear in a specific sheet?

Thanks,

Jess

[MarqueeCrew]

@murrayjl03,

If you use a select tool to bring the columns to the specific sheet, then you can use two output tools to create the sheets.  You can get fancy and use a single output tool, but to keep it simple just try that.

Cheers,

Mark

[murrayjl03]

Great thanks! Once i have the 2 outputs for my 2 sheets how can i get these in the same excel workbook?

[MarqueeCrew]

If you configure each of the output files to write to:   My Output.xlsx

And give each a unique name:  Sheet 1 & Sheet 2

(also configure to overwrite sheet/drop)

That's how you can write twice to the same filename.

[MarqueeCrew · Accepted solution]

Here is a sample workflow.  I added a block until done to help prevent excel write issues.

[MarqueeCrew]

Do you have the block until done in your workflow?

[hegdepavithra10]

@MarqueeCrew 

Hi ,

I have a similar requirement, where in from the same workflow i am trying to output the results to different sheets of the same excel file from alteryx. However, the workflow has one of the output as a simple group of formulas and the other from table tool. Hence i cannot use output tool one both of them. I have to use render tool on one. Like you have mentioned where there output tool, i selected it to "Configure to drop". But its not working. Could you please help.