Output to excel workbooks based on unique field string

[DataSetGo]

Hi - first post! I have successfully created a workflow and have exported the data to excel workbooks, however, I'm stumped by something that likely has a simple solution. I searched for a solution in the community but still am at a loss.

See example column below. My workflow output is creating 6 workbooks per child field but I want to create 2 workbooks based on the Parent fields A & B (A.xlsx & B.xlsx) that includes all the Child field data.

Parent	Child
A	A1
A	A2
A	A3
B	B1
B	B2
B	B3

I tried incorporating a summary tool and unique tool but am still unable to get the results I'm looking for. Suggestions?

Thanks in advance!

[DataSetGo · Accepted solution]

***SOLVED***

I resolved the error myself by changing file path in the formula tool and updating the output tool settings.

[CharlieS · Accepted solution]

@DataSetGo

In your case, use the "Take File/Table Name from Field" option on the Output tool to update the Table name using the [Parent] field. The standard process I recommend is to create a new field since that can be used in a greater variety of scenarios.

EDIT: Looks like you already got that figured out. Nice work!

[DataSetGo]

---

@CharlieS

---

Thanks for the fast response!