Hi Community! I'm looking to iterate a simple input of numbers and iterate multiple times and append each result as a new column every iteration. In this example, I want to multiply the original number by 2 every iteration. Sample input : OriginalNumber1122334455 Desired result (dynamically rename result columns) : OriginalNumberNum1Num2Num3Num4Num511248163222481632643361224489644816326412855102040801606612244896192 I couldn't get the macro to work, and hope I can get some help here! In my sample workflow here, I only want it to iterate 5 times. Any help is appreciated, thanks! Rolling.yxmc

Iterative Macro : appending new column every iterations

Hi Community!

I'm looking to iterate a simple input of numbers and iterate multiple times and append each result as a new column every iteration.

In this example, I want to multiply the original number by 2 every iteration.
Sample input :

Original	Number
1	1
2	2
3	3
4	4
5	5

Desired result (dynamically rename result columns) :

Original	Number	Num1	Num2	Num3	Num4	Num5
1	1	2	4	8	16	32
2	2	4	8	16	32	64
3	3	6	12	24	48	96
4	4	8	16	32	64	128
5	5	10	20	40	80	160
6	6	12	24	48	96	192

I couldn't get the macro to work, and hope I can get some help here!
In my sample workflow here, I only want it to iterate 5 times.

Any help is appreciated, thanks!

Rolling.yxmc

Macros

Iterative Macro

Accepted answers

Raj

@pchong
find the workflow attached, Marco is tweaked a bit

mark done if solved.

3184.yxzp

CoG

Adding columns dynamically is not a very simple procedure, but it can be done. I rebuilt your macro to accomplish the stated objective. Hopefully this is a valuable learning tool for you for: Iterative Macros, Dynamic Replace Tool, & Dynamic Rename Tool