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. Column1Column2ABCa1234ABCb4321a1234c4545a1234d6565b4321z1234b4321f8686 In the picture, the result that I need is highlighted.

Iterative Logic

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.

Workflow

Datasets

Iterative Macro

Accepted answers

DavidP

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.

iterative macro 3.png

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.

iterative macro.png

iterative macro 2.png

iterative pyramyd workflow.yxzp

iterative pyramyd workflow.yxmd

pyramid iterative macro.yxmc

All comments

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

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.

iterative macro 3.png

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

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

iterative macro.png

iterative macro 2.png

iterative pyramyd workflow.yxzp

iterative pyramyd workflow.yxmd

pyramid iterative macro.yxmc

maverick_70

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703