How to output excel per group number/code?

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!

alteryx_example_for_each.xlsx

Input

Output

Macros

Accepted answers

dougperez

The append not work for you?

All comments

dougperez

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

Test.yxmd

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?

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703