Combine multiple True outputs (filter tool) into one file with multiple 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
Hello - I have a bunch of Filter tools where I need to combine all the True outputs into one file, were each True output is its own separate tab. How do I do this?
- Labels:
- Connectors
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @pacbloyd
Can you provide some sample input and expected output It will help us get a better understanding of the usecase.
We will be happy to help : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @atcodedog05 - I'm not exactly sure the best way to do that...
I basically just want to make each True output into its own tab, in one Excel spreadsheet
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @pacbloyd,
1) In case they have SAME schema:
I would create new field after true anchor -- name of Sheet basically. Once this Sheet Name column is added, you can union all True anchors, you can use output tool as shown below. This way, you will have one file named TEST with different tabs.
2) In case they have DIFFERENT schema:
I would use after each true anchor table tool to create table, then also add Sheet Name column. Once done, you can union all items together -- use Layout tool. Important is to select correct Orientation as below.
Once finally you have only one Layout tool that contains all you data, you can add Render Tool (as final output). It can be filled in normally, but Separator is important.
As Render Tool and multiple sheet already has couple of articles here -- sharing one here for more details
Let me know if it was helpful!
Best Luck!
Niky
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@NikyN wrote:Hello @pacbloyd,
1) In case they have SAME schema:
I would create new field after true anchor -- name of Sheet basically. Once this Sheet Name column is added, you can union all True anchors, you can use output tool as shown below. This way, you will have one file named TEST with different tabs
So what's the best way to add that new field? Add a formula tool to each True output?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@pacbloyd, yes after each one formula tool.
In case this solution will works for you -- please feel free to mark it as solved!
Enjoy weekend!
Best Luck!
Niky
![](/skins/images/6056C79A596CAB15526D64C598622101/responsive_peak/images/icon_anonymous_message.png)