Repetitively run workflow for subset of data

Dear community,

I built a workflow for my panel data, which I would like to run subsequently for each year of observation i.e. if year = 1 then run workflow and store result. if year = 2 then run workflow and store result ... combine the outputs. How can I go about this without having to manually copy and paste the workflow over and over again? Perhaps a macro?

Thank you for your help!

Workflow

Macros

Accepted answers

JosephSerpis

Hi @Neico I mocked up an example for you and attached as an Alteryx Package the version of Alteryx I used is 2020.2. If you have an older version then an error will pop up when you try to open it. However these two posts show how to get round that error and open up the Alteryx package.

Post1

Post2

Batch_Macro_Example.yxzp

TheOC

hi @Neico

I managed this using a batch macro:

This runs for each year value within the dataset. You will have to import the macro i have created, and create a workflow like so.

This produces your desired output. I have attached the workflow i have used too!

Hope this helps and hope you've had a great weekend!

Neico.yxmc

Neico.yxmd

Neico.yxzp

All comments

JosephSerpis

Hi @Neico it sounds like you need a batch macro as it will run per year in your data. This article explains how to get started with batch macros. If you have your workflow already built then turning into a batch macro shouldn't be too difficult.

Neico

@JosephSerpis Thank you! I already had the feeling that it would be a batch macro. Is there maybe a template somewhere already that I can use and tweak?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703