how to output multiple files

[Beckyli]

how to output multiple files based on store name

[JagdeeshN]

Hi @Beckyli ,

Please check @Jonathan-Sherman 's response in the below thread. 

Solved: Multiple Output files based on variables - Alteryx Community

[Beckyli]

It is not work, it output one file with multiple worksheet. i want to multiple file with store number as each file name. could you please help me correct it?

[Qiu · Accepted solution]

@Beckyli 
You are almost there. 😁
I made two minor modifications, and it should work now.

[Beckyli]

still not work

[Beckyli]

after i run, show below error.

[DataNath]

Hey @Beckyli, I built a macro that can be used to output to multiple excel files or sheets (whichever you want). All you need to do is download it and insert it into the end of your workflow:

https://community.alteryx.com/t5/Public-Community-Gallery/Output-to-multiple-Excel-files-or-sheets/t...

[Beckyli]

how should i add total row on each export files

[Beckyli]

i want to my multiple files come with total row.

[DataNath · Accepted solution]

@Beckyli before the final output, you could use a Multi-Row Formula to fill in the [Store #] for the rows containing the totals, before then outputting it in the same way as you are currently:

Before:

After:

Result: