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 

Thanks, you still did not shared the error that you are getting.

As the question is does the Block Until Done is failing or something else in your workflow is failing. 

Please share more data. We cannot see your WF and what is happening with the data. So we do not know what you are facing. The fact that there is no data at R does not indicate anything for us as we do not know which data you are trying to output and why do you have a Join tool before the output. It is like walking in the dark, please shed some light so we can help you.

[rohit782192]

You can refer workflow from binuacs .

[Deano478]

I hate to be this guy but no we cant as i assume @binuacs like most of us is just guessing as you are not sharing any useful information about your issue

[OTrieger]

@rohit782192  Thanks.

I would like t o help you based on your original WFs and not based on something that was provided to you. I'm assuming that there is something that you doing incorrectly as you do not get the end result. Without seeing what you are facing it would not be possible to help in away that you can learn form what you are doing incorrectly or forgot to do, etc. That will be the only way to help you. Just sharing with you how I will do it will not solve your issue as that would be my solution and the idea here is to help you solve what you are facing based on what you developed so far. We will not be able to help you with out data and understanding what you are facing.

[binuacs · Accepted solution]

@rohit782192 updated workflow attached

[Carolyn]

What OP might be running into is an error where they try to write to Sheet2 but Alteryx says the file is in use from another process, because Alteryx is simultaneously trying to write to Sheet1. Even adding the Block Until Done, you can still run into this error. 

My team ran into this quite a bit before we were able to upgrade to 2023.1. The fix is to either do a BUD that flows into another BUD since then it'll properly BUD, or I love the CReW's Parallel Block Until Done Tool. 

[OTrieger]

@Carolyn 

I'm not trying to assume what type of error he gets, that is why he should share it with us. But just stating that something did not work without sharing what fails leave me always suspicious about it. Yes, CReW macros are excellent, I'm using them very often. 
Helping others does not means to do the work for them, no no no. If you created a WF that fails I'll be happy to help you find what fails and share what can be done to overcome it, so the person can learn from it. 

[Carolyn]

@OTrieger, You're absolutely right. The issue/error needs to be clarified since I'm joining in the guessing game. 

I'm mostly thinking that based on OP's replies and then what binuacs built (the second time), it may not work due to the error that I said, based on my past experiences/frustrations. But to your point - guessing is less than ideal and more info is needed

[rohit782192]

Hi,

How can we print only Header without any data that is null in Excel.