I need to output to two different excel files

[znooredeen004]

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?

[CharlieS · Accepted 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]

[znooredeen004]

Thank you!! This really helped!