Trying to make first loop

Question

Hi guys,

I am trying to make my first loop in alteryx, not sure if i can say it macro or some other way to achieve it.

Task,

I have a table , it have basically 3 key columns say X , Y , Z,

For example Row 1 case

Check if data in coulmY or Z  is present in any data in column X, if not found go to row 2.

If found, then say suppose row 1 Y data = row 5 X data then I want row 1Y = row 5 Y data

same applies for column Z data.

However if the new found data can be again a matching data with column X, so this process repeats until no match found.

I have create single loop as below but further I dont know how to make it repeat process. I have attached workflow what i created till now,

Loop.PNG

samson211 · Answer

I will check and try, thanks.

If suceess will report back. Thanks again for the feedback.

abacon · Answer

For loops in alteryx, you will want to use an iterative macro. Here is a video on how to set them up that I found very helpful.

https://www.youtube.com/watch?v=AByfTPqrUrQ

ChrisTX · Answer

For this part:  this process repeats until no match found

you'll likely need an Iterative macro

And this part:  how to make it repeat process

you "may" need to use a batch macro

So I'm guessing a batch macro that calls an iterative macro?  With more complicated examples like you mentioned, you should probably include sample input, expected output, and one or two step-by-step process examples, written in language as simple as possible.

To learn about macros, at the top of this page check out:

Learn > Academy > Interactive Lessons > Macros
Learn > Academy > Videos: search for "Batch", and search for "Iterative"

Chris