How to create multiple excel output file

[prpanw]

Hi Folks,

I have prepared the below data in Alteryx and now I want to save a seperate excel file for each broker parent.

Can somone help me how to save excel file for each broker parent?

Chubb Reference	UMR	Department	Insured	Broker Parent	Year of Account	Inception	Expiry	Last Paid Date
ABC	B1233444	Avia	CANADA TIER II OPERATORS GROUP	Marsh Ltd	2022	01/11/2022	31/10/2023	30/12/2024
ABC	B1233444	Avia	PRECISION AIR SERVICES LIMITED	Marsh Ltd	2022	01/12/2022	30/11/2023	30/09/2023
ACC	C12344	Avia	SKYMARK  INC	Arthur J Gallagher (UK) Ltd	2022	15/12/2022	14/12/2023	05/08/2024
ACC	C12344	Avia	Arrows Aviation	Arthur J Gallagher (UK) Ltd	2022	01/03/2022	28/02/2023	01/01/1900

[alexnajm]

Create a custom file path with a Formula tool, then configure the Output Data tool to write there: Output to separate Excel files

[prpanw]

@alexnajm  it was amazing thank you for soluton.
I have one more question can we format the data while saving each spreadsheet becaseu some columns width are too short. Is there any way we can fix column width

[alexnajm]

It will default to whatever the column width is in the Excel, so you would have to change it in the Excel, save it, and "preserve formatting on overwrite" with a range in the Output Data tool