Looping Macro

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,

Mapping Data.xlsx

Data1.xlsx

Macros

Accepted answers

KSowers10

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!

Looping.yxzp

Looping.yxmd

Looping Macro.yxmc

All comments

KSowers10

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!

@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

KSowers10

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 Thank you! It's Perfect.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703