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,
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
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.
I will check and try, thanks.
If suceess will report back. Thanks again for the feedback.