Hello all, I have a simple iterative macro that I am using to restart an in-DB pull whenever the row counts are below a certain threshold. The issue is that I need this to be dynamic so I can feed it a variety of inputs, while still only having to maintain one primary .yxmc file.
Below is the entire iterative macro (the blue dot is a standard macro, containing the conditional test logic).
One potential solution I thought of was to package the inputs that need to be dynamic into their own macros, and then in the iterative macro, I am hoping I can call the "input macro" dynamically, thereby allowing me to set the file path via the iterative macro configuration, like so:
And the iterative macro would then look something like this (just an example--this doesn't actually work).
Is this possible? Anyone know any tricks to get around this issue and call macros by file path? Is there a better approach entirely to achieve my objectives? Any and all help is greatly appreciated.
