Combine multiple True outputs (filter tool) into one file with multiple tabs

[pacbloyd]

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?

[atcodedog05]

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 : )

[pacbloyd]

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

[NikyN]

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 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Rename-sheet-in-Render-Tool/td-p/42171...

Let me know if it was helpful!

Best Luck!

Niky

[pacbloyd]

---

@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?

[NikyN]

@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