One Excel with Multiple Sheets

[rohit782192]

Hi,

In Alteryx how can we save output in one Excel and Multiple sheet.

I.e Sheet1, Sheet 2, Sheet3 . It should also handle with 0 record and a column header should be there in sheet.

[OTrieger]

@rohit782192 
You should define the sheet name in the output path and ensure that you are using Block Until Done to write each output separately as you will write all the output to the same file. After .xlsx you will need to add ||| and then the sheet name.
,,,\report.xlsx|||Sheet1
,,,\report.xlsx|||Sheet2
etc.

So it means that you will need to set the file path with valuables to get the different sheet names

[rohit782192]

Block until done is not working. I have tried

[cjaneczko]

Each sheet needs it own branch on the Block Until Done. You can also use Control Containers for each output. 

[rohit782192]

I don't have control container. I am on the lower version 

Block until done also I tried on each but no luck.

[cjaneczko]

Can you include a screen grab of your workflow?

[binuacs]

@rohit782192 sample workflow attached

[OTrieger]

@rohit782192 
Which error do you get, just to indicate that it is not working is not enough detailed comment. Please share the error message that you are getting.

[rohit782192]

@binuacs 

I am getting the output from join tool.  J and L Contains Data and R Does Not.

I want all the Data in an Excel that is coming in Join.

Sheet1 = Join.

Sheet 2 = Left

Sheet 3 = Right

This is the format i am expecting. Yours Solutin is taking row by row in a Different spreadsheet.

[Deano478]

@rohit782192 Please show us all what you have tried yourself so far as nobody on here is able to follow your issue without proper screenshots, sample data and or a workflow