Splitting File into Multiple Cascading Files based on Column Content

[rdanella]

Hello,

I have a master file that I need split into multiple smaller files based on values within the data. It is one file that I need split by team, and then I need a file for each individual person on that team.

Team Member	Team
Person 1	Team A
Person 2	Team B
Person 3	Team C
Person 4	Team A
Person 5	Team B
Person 6	Team C

In this example I need separate files for Teams A,B,C and then individual files for each team member. 

I know that you can use the Output tool for this, but can it do it in a cascading fashion?

Thank you!

[BS_THE_ANALYST · Accepted solution]

@rdanella You could do it like this:

The top data stream will generate different files for each team

The bottom one will create a separate files relating to each individual:

[rdanella]

This is great, but the split files are saving as one file instead of individuals. Do you know how to get them to save individually?

[RobertOdera]

Hi, @rdanella 

Consider the below.

Leverage the Summarize and Sort Tool prior to Output.

Please mark it as an acceptable solution if this works for you.

P.S. the error is because the output is looking for a destination to write to - in your case, once you select that, there will be no error.

[BS_THE_ANALYST]

@rdanella mine split out as expected:

Do you have this option set to append:

[rdanella]

When I have that setting the file still saves as one, with each split saving as an individual tab. It also then adds "Sheet 1" to each tab name, instead of the desired value.

Example:

• Sheet1Person1
• Sheet1Person2

Does it matter that I am saving as an excel file vs a csv?

[BS_THE_ANALYST]

@rdanella yes, because you are outputting this into an excel file (that's how it behaves). Stick to CSV and you will get your expected output! :-D

[rdanella]

Perfect!

Thank you!