I have a workflow that takes 4 inputs, source (db connection), destination (db connection), period and a type. When the user selects the source and destination from the drop down lists it eventually swaps those values into the input and replaces those strings with the appropriate db connection.
The problem is the other 2 which are list boxes which can be one or multiple values. I am able to swap those values into my input and it returns the correct row counts regardless of if you selected 1 or multiple values, the problem I'm encountering is that a Post-SQL stored procedure has to be run after the data move to destination selection is made.
This would be fine if only one value was selected as the Stored Procedure design that exists only takes 1 of each parameter type at a time. Unfortunately I do not know how many the user will select thus I'd have to iterate over this stored procedure x times passing those values in one at a time and executing it post-sql x times.
I suppose the easiest solution would be to alter the stored procedure to accept as many values as you want to pass in but I was hoping there was a way in Alteryx to:
Execute the stored procedure x times, passing in the drop down list values each time as we iterate over them but I haven't found a way to do that yet (easy enough to do in my SQL input statement to grab the data as we can just use "in", not so much in procedure). Is this something an iterative macro might handle? The overall workflow executes 5 other workflows (of which this is one) depending on which "type" is selected in another drop down list so the branching is getting a bit busy as it is, so I'm hoping to just insulate this problem within a small area if possible.
Thanks
