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

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-Excel-file/ta-p/1241