alteryx split 1 excel file with multiple tabs with different schema into multiple files wi

[Til22]

I am struggling to find an answer for this one.

I have one master file with 3 tabs (each with different schema).  I would like to split this file into multiple subset files which contain the same 3 tabs.

For example, the master file contains 3 tabs.  I would like to filter on the field company and output each tab to a file, one for ACME and one for XYZ.

     

I have attached a sample dataset. 

Although the sample data only contains two company names in real life I will be handing hundreds of companies so dynamically outputting the files by company name would be ideal.

Thanks in advance.

Til22

[Watermark]

So you're trying to take each of these tabs, and for each company you're creating a file. Each file would have the same three tabs?

So in this case 2 files..... Acme & XYZ. Then each of those 2 files would still have the 3  different tabs?

[Watermark]

You may want to use a formula tool to create a path, then a sheet name: See the following 3 images

You'll be grouping by file name (dictated by fields with the values) and by sheet names again identified by field values. 

Give that approach a try.  Let me know if you have questions. 

[Til22]

Exactly.  That is what I am trying to achieve.  

[Til22]

Thanks.  I can see the logic behind that for the out but how do I pull the 3 tabs of data from the one master file ?

[Til22]

*output