For loop in alteryx

[Jocelynupup]

Hi there,

In this workflow, I want to find the web order of the POS ID. But Alteryx doesn't have the "for loop" function, I was wondering how to realize it in Alteryx.

The rule is we don't stop the loop until the original ID is 0. Then we find the web order based on its ID. I also include the flow chart for a better understanding.

table1
ID	original ID
AA	0
AB	AA
AC	AB
AD	AC
BA	0
BB	BA
BC	BB
CA	0
DA	0
DB	DA

table 2
Initial ID	web order
AA	111
BA	112
CA	113
DA	114

result
POS ID	web order
AC	111
BC	112
CA	113
DB	114

Thanks,

Jocelyn

[apathetichell]

Use an iterative macro inside of a batch macro.

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Macros

[CoG]

As it turns out, you don't need the batch macro at all. Here is a sample that only utilizes an iterative macro:

Main Workflow:

Iterative Macro: