What type of macro allows for the execution of a process multiple times with varying inputs?

The type of macro that allows for the execution of a process multiple times with varying inputs is an iterative macro. This functionality is specifically designed to perform repeated iterations of a particular process where each iteration can utilize different inputs. It's particularly useful in scenarios where you need to refine results or when the output of one iteration serves as the input for the next iteration, thereby enhancing the flexibility and power of data processing within Alteryx.

Iterative macros can create loops that enable the workflow to run until certain conditions are met, or until a specified number of iterations are completed. This is a crucial feature for handling complex data analyses that require repeated calculations, adjustments, or simulations, making it distinct from other macro types that serve different purposes.

Batch macros, in contrast, are designed to process a set of inputs all at once rather than iteratively, while standard macros are reusability components that do not focus specifically on iteration. Value macros are typically not a recognized standard term in the context of macro types within Alteryx, further differentiating iterative macros in their unique capacity for repeated execution with varying parameters.