Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Looping Macro

Learner09
8 - Asteroid

Hello All,

 

I am trying to build a Looping Macro for one of my analyses. I have two data sets

1. Data1

2. Mapping Data

 

I am trying to design a looping macro that goes to the Mapping data file and picks the first customer name and then goes to the Data1 file and searches for that customer and fetch and provides the information related to that customer and then goes to the second customer in Mapping Data and performance the same things and looping go on.

 

I know this will achieve with normal Alteryx flow and tools, but I need to develop Looping Macro so that I will able to use it in the different flows. I am very new in preparing Macro in Alteryx, I believe this is also good learning for me as well.

 

Thanks,

4 REPLIES 4
KSowers
Alteryx
Alteryx

Here you go! You can add any calculations or tweaks inside the macro to perform anything additional that you would like. If this works for you, please mark as a solution! If not, let me know how we can edit it to do so! 

Learner09
8 - Asteroid

@KSowers Thank you. It's working. Could we automate the Filter? For Example, if I use a different set of data in which Apple does not exist. Instead of customer I have data in which geographies are there, we update the Marco input, and then Filter automatically picks the geography first name in the list, or if that is not available in the data it skips and reads the rest of the list. Is there any way we can automate the filter so that I can use this macro for various analyses?

 

Rest the macro works Perfectly, Thank you :)

KSowers
Alteryx
Alteryx

Here you go. I added a section on the left that allows you to type in which column you would like to perform the filter on. 

If this works for you, please mark as a solution!

KSowers_0-1672236436951.png

 

 

Learner09
8 - Asteroid

@KSowers Thank you! It's Perfect.

Labels