Required multiple output in one excel on different tabs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
We have multiple outputs, but we want those outputs in one excel on different tabs.
Could you please share option for to get the data.
Regards,
Mahesh
Solved! Go to Solution.
- Labels:
- Designer Cloud
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Maheshp
I think we are looking at the Block Until Done tool
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Block-until-Done/td-p/572140
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Not working, as we have multiple outputs and require in one excel in different tabs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Using multiple block until done should work as shown here -
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Maheshp
if you have same columns in every sheet
you can achieve this easily using output tools capabilities
please add some sample input and expected output.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Raj i have already attached an excel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Maheshp
your excel does not have any sample data that is just screen shots of requirement
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Maheshp the Excel only has 2 images. The block until done tool is what you need to do this, but in the image, you are showing browse tools. You'll need to use output data tools to send the data to Excel with the different sheets identified. You can change the highlighted name below to identify the tab names. Put a block until done tool just before each of these so the timing of writing the sheet to Excel does not interrupt another sheet being written. A single tool in front of each output will suffice. The numbers on the block until done tool don't matter for this application.
If you are trying to send the output from the Browse tool to a file that already exists, you will get a message about replacing the file. This does not replace the file. The wording is a little off. The message is just to let you know that the file already exists. If you try to send it to a sheet that exists, it will fail. The tab name must be different to export to Excel this way.
 
Hopefully these help answer your question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Raj Yes, in first screen shot i have highlighted the output which comes through data and in second excel screen shot we required the output like that way.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Maheshp did you see my post? Did it help?
