I inputted an excel file which I use alteryx to clean and format the way I'd like.
For example my cleaned data looks like this:
Name State Income Tax
John Alabama 4000 250
John Arizona 5000 350
Bob New York 2000 150
Bob Georgia 10000 600
I want to output to two different/separate excel files based on the name column. First excel file would be John. Second excel file would be Bob. I know how to do it if I were to output different sheets but for this purpose I need to output to two separate files based on the name. Is that possible?
Solved! Go to Solution.
@znooredeen004 wrote:Is that possible?
Absolutely!
Use a Formula tool to write the output file path that include the [Name] field. The Output tool can then be configured to use this file path field that you've just created and will will write the appropriate records to the appropriate files.
When writing to Excel with the Output tool, don't forget to include a sheet name in the file path.
"%temp%\Results_"+[Name]+".xlsx|Sheet1"
If you instead want one file with a sheet for each name, here's the expression modified for that:
"%temp%\Results.xlsx|"+[Name]
Thank you!! This really helped!