How to loop and increment a value in filter tool by 1 and write all the results to a file.
- 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,
I am quite new to Alteryx and especially the Macros. My requirement is fairly simple. I want to increment a value by +1 in the filter tool by keeping the operator as "<" . I want to loop through all the Record_ids to get the final multiplied "Multiplied_score" for all the 15 record_ids.
I have attached the sample workflow.
I am not sure, if Batch macro or iterative macro is the right way to go for this simple use case. Please guide me. All i need is the value in the formula tool to be incremented by 1 and stop at the last record_id.
I specifically want to use Macros, I know the formula tool can achieve this. I want to know how this can be done.
Thank you!
Solved! Go to Solution.
- Labels:
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @akshaydalvi5217 ,
I am not sure if this is what you want.
I followed your words to "increment a value by +1 in the filter tool and loop all the record_ids".
Please let me know if anything is wrong.
Workflow
Macro
Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much Yoshiro!
![](/skins/images/6056C79A596CAB15526D64C598622101/responsive_peak/images/icon_anonymous_message.png)