Iterative Logic

[maverick_70]

Hello,

I have a data in which I have to run an iterative loop. Although, I am having trouble to do it in Alteryx.

Attached is the Sample data and the logic and the result I am looking for.

Column1	Column2
ABC	a1234
ABC	b4321
a1234	c4545
a1234	d6565
b4321	z1234
b4321	f8686

In the picture, the result that I need is highlighted.

[cmcclellan]

Is it always 3 levels, or can it be X levels and you have to loop to the bottom?

If it's 3 levels, you can just join the data to itself 3 times over and you will have the result.

If you have to loop to the bottom you will need to create an iterative macro to do it.

[maverick_70]

There are more than 3 levels. 

[DavidP · Accepted solution]

Hi @maverick_70 

This problem has been driving me crazy all week, which makes the solution all the more satisfying!

I created a slightly bigger dataset with slightly easier names.

I then built an iterative macro to solve the problem. The macro limit is set to 10 levels, but this can be increased.

I've attached the files as a package - try this first. If you have problems with this due to different Alteryx versions, open both the macro and workflow in a text editor and change the version number in the 1st line to your version. Then save the macro in your macros path and you may have to re-insert the macro in the workflow. 

Let me know if you have issues with this and also your version of Alteryx and I'll try and help.

[maverick_70]

This is great. Works exactly as I needed. Thank you