How to loop and increment a value in filter tool by 1 and write all the results to a file.

[akshaydalvi5217]

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!

[Yoshiro_Fujimori · Accepted solution]

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

[akshaydalvi5217]

Thank you so much Yoshiro!