How to create multiple excel output file

Question

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 ReferenceUMRDepartmentInsuredBroker ParentYear of AccountInceptionExpiryLast Paid DateABCB1233444AviaCANADA TIER II OPERATORS GROUPMarsh Ltd202201/11/202231/10/202330/12/2024ABCB1233444AviaPRECISION AIR SERVICES LIMITEDMarsh Ltd202201/12/202230/11/202330/09/2023ACCC12344AviaSKYMARK  INCArthur J Gallagher (UK) Ltd202215/12/202214/12/202305/08/2024ACCC12344AviaArrows AviationArthur J Gallagher (UK) Ltd202201/03/202228/02/202301/01/1900

alexnajm · Answer

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

prpanw · Answer

@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 · Answer

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