How to output excel per group number/code?

[mrichman]

Hi Community, 

I'm not sure how I can perform it on Alteryx. However, I would like to output per group into a seperate excel. Examples are in the attachment.

I was think of a for each but probably there is a another way. If you need more information, please do not hesitate to ask 🙂 

Thanks in advance! 

[dougperez]

Create the filename in a formula tool using the the Group Collumn, I attached a example.

[mrichman]

Ah Doug Perez, 

Thanks for your assistance! I think I explained it too short. 

The output needs to be appended into a template sheet. Therefore, I need to have them separated and do a number of calculations (not in dummy data, but in real data). Is this feasible? 

[dougperez · Accepted solution]

The append not work for you?

[mrichman]

unfortunately not 😞 

[Luke_C]

Hi @mrichman 

As @dougperez you'll need to create the filename as a field (fullpath) to output separate excels and update the output tool accordingly.

For templates, you can output to a range and preserve formatting. One thing that works well is keeping a template file and updating for each run. There's a detailed example in this post:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Clearing-Data-in-Template-before-Overw...

[dougperez]

Ok.

Have you tried to read the model, append the rows into designer then output into another file ?

[mrichman]

@dougperez  Tried your recommendation once again - a little bit tweaking here and there, it works! Thanks for the assistance! 

@Luke_C Thanks for the suggestion too!