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 MemberTeamPerson 1Team APerson 2Team BPerson 3Team CPerson 4Team APerson 5Team BPerson 6Team 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!

Splitting File into Multiple Cascading Files based on Column Content

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!

Input

Output

Parse

Transformation

Documentation

Accepted answers

BS_THE_ANALYST

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

All comments

BS_THE_ANALYST

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

For_rdanella.yxmd

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703