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!
Solved! Go to 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:
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?
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.
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:
Does it matter that I am saving as an excel file vs a csv?
@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
Perfect!
Thank you!