Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Creating a batch macro that generates individual Excel tabs for each breakdown

latte
5 - Atom

Hello,

 

This a fake sample of survey data on group plans. The plan has a unique ID and basic plan information such as industry, assets, number of participants, contributions. We create groups based on their asset and participant figures.

 

Using the asset and participant groups, as the breakdown i want a macro that will generate a new Excel for each breakdown and for each metric (assets, number of participants, contributions). This is only a subset of the columns but ideally, the final output will contain all the various breakdowns in one tab.

 

I currently run two of the nearly identical workflows to generate an excel with each workflow's output as separate excel tabs. Is there a way to just have a batch macro so it runs through every breakdown (participant group, asset group)?

 

I believe I'm missing some tools in the workflow but don't know where to begin. I would like a workflow with as few edits as possible so someone with little Alteryx experience can run it.

 

Any assistance from the community would be great!

 

version 2022.1 x64

0 REPLIES 0
Labels