2 output from 1 workflow in 2 different sheet of same excel output
- 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
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?
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hypothetical example, the below 2 output i need in sheet1 and sheet2 of same excel output file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
![](/skins/images/24BD88A84717269788D92E042DF65D77/responsive_peak/images/icon_anonymous_message.png)