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.
SOLVED

Converting A Nested Batch Macro To An Iterative Macro

rheepa
7 - Meteor

Hi All,

 

I would like to learn how to convert the attached nested batch macro to an iterative macro. Note: I created a toy example for learning purposes. I am grouping by name and date and calculating an average. In this case, I already know that I can simply use a Summarize Tool; however, for more complex analysis, I will need to use this nested batch/iterative macro logic. Can someone help me do this?

 

Thanks in advance!

2 REPLIES 2
SPetrie
13 - Pulsar

We may need a bit more information on what you are trying to accomplish since there really isnt much to iterate on with your example data.

I took a stab at it anyway and created a name/date grouping number and used it to do the iterating. Hopefully that is sufficient to demo the iterative macro for you. Let us know if this isnt quite what you were looking for.

SPetrie_0-1657829217753.png

SPetrie_1-1657829246555.png

 

 

rheepa
7 - Meteor

Nice example. Thank you!

Labels