Recursion is a common task that we perform while creating ETL process. There should be some way in the macro to allow recursion process, i.e. taking value from the output in macro and providing it as input to the control parameter.
Adding this feature could improve ETL capabilities within Alteryx