How to do iterative process?

[Shami]

Hi, I've attached the file of expected output. Here, initial value of A is 1,  then have to calculate C+x=(A+x-1)+B then C+x value should be used in A+x column to perform some calculations and have to iterate 4 times(x=1 to x=4).Thanks in advance!

[ChrisTX]

You'll need an Iterative macro

Search for "Iterative" on the video training index and watch the videos: https://community.alteryx.com/t5/Videos/Video-Training-Index/td-p/45161

This training may be helpful: 

Advanced Macro Development

Have you been building macros already and want to take it to the next level? This session will cover more options for making robust macros. Learn how iterative macros allow a macro to run repeatedly until the desired result is achieved.

https://community.alteryx.com/t5/Archived-Training/Advanced-Macro-Development/td-p/43862

And the Interactive Lessons page should help: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Macros

Chris