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
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?
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
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: th-cam.com/video/ceFXqC1Djqo/w-d-xo.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!
@@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.
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!
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?
Very clear, concise and helpful mini-series! Going to share with my team! Thank you!!
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.
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
Muy claro el concepto. Excelente video. Felicitaciones!
Thank you for the wonderful videos :) :) Waiting for more video's to enhance the skills in Alteryx.
Great tutorial, short and precise. this is just what i was looking for. Thanks a lot.
You're welcome! Glad it helped
Explained it really well....Thanks
Marvellous series. Learnt so much in a really short time span. Thanks a lot.
Great to hear! Thank you for taking the time to feed that back
Such a great explanation on the topic
Thanks for this. I am trying to build a rolling StDev and it is causing a lot of grievances.
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?
If we need to calculate last cash flow to achieve the specific IRR rate, given we have the dates and cash flows
Very helpful tutorial
what if we need to calculate the last cash flow need to achieve a specific IRR rate give the cash flows and dates
Thanks a lot for these helpful videos !
Very well explain its really help me.. Thanks
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
Is there any way that I can loop over a set of columns and do the same calculation on each column?
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: th-cam.com/video/ceFXqC1Djqo/w-d-xo.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!
@@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.
Nice video but I am getting output in the Iterative Output Anchor
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!
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?