Iterative Macro : appending new column every iterations
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Iterative Macro
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
./
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Raj,
Unfortunately the video is not helpful.
I understand that piece of iterative macro, but it's a simpler one because it doesn't append the result each iteration.
It only output one single output and that's easier to implement.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@pchong
find the workflow attached, Marco is tweaked a bit
mark done if solved.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Raj!
I was hoping the macro can do all the cross tab and so on, but this works as well!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Andrew!
Dynamic Replace is new to me and it's very useful!
![](/skins/images/33644471E927638F516C93A75ADDEE18/responsive_peak/images/icon_anonymous_message.png)