write to excel file and name file based on a field

[TeamTJ]

Is there a way to write data to an Excel file, naming that Excel file according to the value of one of the fields in my data?

For example. if I have the values "Bob" and "Fred" in my UserName field, I'd like 2 files "Bob.xlsx" and "Fred.xlsx" created with their data respectively.

[CharuGupta · Accepted solution]

Hi,

You can use Output tool configuration 'Take File/Table Name from field' for getting multiple sheets based on a field UserName in your case.

This article might be useful.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Output-to-multiple-sheets-within-an...

[TeamTJ]

Thank you!  That led me to the biggest help: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Output-to-separate-Excel-files/ta-p...