Alteryx Iterative Macros

Learn all about Iterative Macros in Alteryx with Molly Hatch
Links
----------------------------
- Macro file at til.bi/MollysIterativeMacro
- www.thedataschool.co.uk/marc-...
- www.thedataschool.co.uk/will-...
- www.thedataschool.co.uk/david...
- www.thedataschool.co.uk/jerem...
- community.alteryx.com/t5/Alte...
- community.alteryx.com/t5/Vide...
- community.alteryx.com/t5/Engi...
- community.alteryx.com/t5/Alte...
- community.alteryx.com/t5/Alte...
----------------------------
Join our Meetup group to keep an eye on all our training, webinars and events at til.bi/talkdata

[@sharonpaschalmba5268]

Very clear, concise and helpful mini-series! Going to share with my team! Thank you!!

[@neelimakammila7891]

Thank you for the wonderful videos :) :) Waiting for more video's to enhance the skills in Alteryx.

[@brunocordova5808]

Muy claro el concepto. Excelente video. Felicitaciones!

[@arunprabhu6116]

This is video is Marvellous, so much clarity towards the topic. This is one of the best video for learning the Iterative macro. Kudos to channel.

[@amitojsingh3489]

Hi Molly, many thanks for sharing this video, this was very useful, I am in the process of building a logic which requires me to loop through a few steps until a condition is false, so i will try to use this as a good starting point. Thanks for walking us through

[@danishimam1461]

Great tutorial, short and precise. this is just what i was looking for. Thanks a lot.

[@theinformationlab]

You're welcome! Glad it helped

[@sankimalu]

Marvellous series. Learnt so much in a really short time span. Thanks a lot.

[@theinformationlab]

Great to hear! Thank you for taking the time to feed that back

[@TheCarlBrink]

Such a great explanation on the topic

[@avikrishna4325]

Explained it really well....Thanks

[@datavizenthusiast3560]

Thanks a lot for these helpful videos !

[@SebAnt]

Very helpful tutorial

[@sagarsawant4656]

Very well explain its really help me.. Thanks

[@AyushKhandelwal-rh4tl]

If we need to calculate last cash flow to achieve the specific IRR rate, given we have the dates and cash flows

[@TheRush05]

Thanks for this. I am trying to build a rolling StDev and it is causing a lot of grievances.

[@AyushKhandelwal-rh4tl]

what if we need to calculate the last cash flow need to achieve a specific IRR rate give the cash flows and dates

[@jaicotman7434]

How would one write this same iterative macro to call down data from a live database in chunks to then run through your workflow and then write data in chunks? Is there a tutorial on that use case?

[@himanshupathak5023]

Nice video but I am getting output in the Iterative Output Anchor

[@Sanjay-TheExplorer]

Not sure what I am doing wrong, video didn't helped me to get a fair understanding of what we are doing in certain scenarios and also the last files when we're trying to insert macro in alteryx tool

[@ossamaahmed6028]

great tutorial, i have one issue if any one finds a solution please share it with me
when using number of years by a constant number say like 5 the macro reaches whenever I'm using an input of any number containing 5 ! same with other numbers if you use 1 it reaches max when using any input that contains "1" like 12 but it works with any other numbers like 99!

[@theinformationlab]

Hi, it sounds like the configuration of your filter tool inside your macro may be using a Contains() function instead of an equals sign. This would definitely cause the macro to reach its iteration limit when the iteration number reaches a value which contains the digit used as an input to the macro. Check to see if this is the case in your macro. If it isn't then please give me some more details of how your filter tool is set up inside the macro?

[@Monduras]

Is there any way that I can loop over a set of columns and do the same calculation on each column?

[@theinformationlab]

Hi Monduras, If you want to do the same calculation on a set of columns, the simpler option would be to use a Mutli-field formula Tool. We recently uploaded a video explaining the tool: ua-cam.com/video/ceFXqC1Djqo/v-deo.html.
The basic set up is to specify which columns to do the formula on with the list of check boxes at the top of the configuration pane. Then at the bottom of the pane write the formula you want to act on each column. If you want to specify the selected field you can use [Current Field] in the formula. Further information can be found in this blog: www.thedataschool.co.uk/nathan-purvis/using-the-multi-field-formula-in-alteryx/
Let us know if this helped!

[@Monduras]

@@theinformationlab thank you for the great response, the problem I have with multi tool is it doesn't allow me to use previous rows in the formula, so i can't make a dynamic rolling average.