how to output multiple files based on store name
@Beckyli You are almost there. 😁I made two minor modifications, and it should work now.
@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:
Hi @Beckyli ,
Please check @Jonathan-Sherman 's response in the below thread.
Solved: Multiple Output files based on variables - Alteryx Community
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?
still not work
after i run, show below error.
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/ta-p/951995
how should i add total row on each export files
Thank you very much.
