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.
@sharonpaschalmba5268
3 жыл бұрын
Very clear, concise and helpful mini-series! Going to share with my team! Thank you!!
@brunocordova5808
Жыл бұрын
Muy claro el concepto. Excelente video. Felicitaciones!
@amitojsingh3489
3 жыл бұрын
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
@avikrishna4325
3 жыл бұрын
Explained it really well....Thanks
@neelimakammila7891
2 жыл бұрын
Thank you for the wonderful videos :) :) Waiting for more video's to enhance the skills in Alteryx.
@sankimalu
3 жыл бұрын
Marvellous series. Learnt so much in a really short time span. Thanks a lot.
@theinformationlab
3 жыл бұрын
Great to hear! Thank you for taking the time to feed that back
@danishimam1461
3 жыл бұрын
Great tutorial, short and precise. this is just what i was looking for. Thanks a lot.
@theinformationlab
3 жыл бұрын
You're welcome! Glad it helped
@TheCarlBrink
2 жыл бұрын
Such a great explanation on the topic
@SebAnt
Ай бұрын
Very helpful tutorial
@datavizenthusiast3560
3 жыл бұрын
Thanks a lot for these helpful videos !
@sagarsawant4656
3 жыл бұрын
Very well explain its really help me.. Thanks
@TheRush05
3 жыл бұрын
Thanks for this. I am trying to build a rolling StDev and it is causing a lot of grievances.
@AyushKhandelwal-rh4tl
2 ай бұрын
If we need to calculate last cash flow to achieve the specific IRR rate, given we have the dates and cash flows
@AyushKhandelwal-rh4tl
2 ай бұрын
what if we need to calculate the last cash flow need to achieve a specific IRR rate give the cash flows and dates
@jaicotman7434
3 ай бұрын
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
3 жыл бұрын
Nice video but I am getting output in the Iterative Output Anchor
@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?
@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
@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: kzitem.info/news/bejne/xJt8vqV5anabpKQ. 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.
Пікірлер: 26