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

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

SampleData.xlsx

Output

Batch Macro

Accepted answers

All comments

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 ?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703