Looping in Alteryx

Hi community,

In Alteryx I tried to rebuild a logic that you can find attached in my Excel file under the tab scenario.Mainly it needs to recalculate different variables over a certain time horizon. Variables first need to be calculated for T1 (time 1) and are used as an input for T2 and so on. I was wanting to work in Alteryx with a multifield formula, but it seems not possible to calculate multiple variables with the same tool. However then I chose for the most easy (but cumbersome) solution and copied all my tool for T2 to T3/T4/T5,..

Is there not an easy way to loop through the same tools (instead of copying) in a certain way (macro output tool?) & how exacty? I also attached my Alteryx workflow.

Cheers,

Tom

EXAMPLE.yxmd

AllocationLogic_Recalculation.xlsx

Macros

Accepted answers

estherb47

Hi @TDevrie6

I'm thinking macro as well, but perhaps an Iterative macro instead. You'll need to loop a number of rows through the process together, not just one line at a time.

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-create-an-Iterative-Macro-The-Collatz-Conjecture-Alteryx/ta-p/108830

Let me know if this helps.

Cheers!

Esther

All comments

meads

Hi Tom,

You are on the right track it seems, and you identified a use case for a macro which is sometimes the hardest part. From your post, it sounds like you are looking for whats called a Batch Macro in Alteryx, where you can loop through a set of values and perform logic on each value being looped through, in your case the recalculation. I have shared a link to batch macros, let me know if you have any specific questions.

Alteryx: Batch Macro

Batch Macro Tech Details

estherb47

Hi @TDevrie6

I'm thinking macro as well, but perhaps an Iterative macro instead. You'll need to loop a number of rows through the process together, not just one line at a time.

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-create-an-Iterative-Macro-The-Collatz-Conjecture-Alteryx/ta-p/108830

Let me know if this helps.

Cheers!

Esther

TDevrie6

Hi Esther,

Thanks a lot! Iterative Macro was indeed the solution for my use case! 🙂

I do not know if you have experience with the Alteryx workflow, but I was wondering if you would know if it is possible to upload a workflow with a macro to the Gallery? If yes, the iterative macro also needs to be added to the Gallery next to the workflow?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703