Alteryx - Dynamically Pass a Value to SQL Stored Procedure

Big thanks to Denny Marshall for suggesting the content in this video. I've done Interface Tools before but never got into the details of passing values to a stored procedure. So here we go!
#NPT #Alteryx #SQL #Analytics

[@KennethBlack]

Nicely done Nathan. I have not tried to modify stored procedures within Alteryx, so this was a great example for me. I always appreciate your succinctness, pace and excellent commentary.

[@NPT]

Thanks, Ken! I always appreciate the kind words. Keep on making stuff happen my friend! 👍

[@omaryda]

This was SUPER helpful. Thank you sooo much!

[@bhanubrahmadesam4508]

Very nice explanation Nathan. Just what I'm looking for.

[@NPT]

You're welcome, Bhanu!

[@Genovia816]

Thanks for sharing Nathan

[@Lephaswi]

Is there a way to pass a table type or a list as a parameter to a stored proc using Alteryx?

[@bhanubrahmadesam4508]

hi Nathan,
I have a workflow that I want to run say 50 times by passing 50 different values. Using this video I was able to parameterize the workflow and was able to pass one parameter at a time. But if I were to run the same for 50 times, instead of running for 50 times passing 50 different parameters each time, can we have all those 50 input parameters in a file and then create a workflow in such a way that it reads the input parameters file and run for all the values in that file one by one. I wasn't able to find a good solution for that. Could you please help me with this scenario. Please let me know if the ask is unclear/irrelevant. Thanks in advance.

[@drkenny7928]

Did you get any help on this. I’m in the same boat

[@arshisiddique1612]

Thanks for explaining. I have a stored procedure which contains a single parameter and parameter value is like for example if i will pas forecast as a parameter it will fetch forecast data so we have multiple parameter value and we want to dynamically select parameter value in Alteryx, so which interface tool would be consider ? Can you please assist me

[@NPT]

Hi Arshi, thanks for the question. What is the data type of the parameter in the stored proc?

[@arshisiddique1612]

@@NPT nvarchar

[@NPT]

@@arshisiddique1612 I would use the "Text Box" tool. Then you may want to validate the user input before passing it to the stored proc. Especially, if there are certain text values you don't want coming over to the query.

[@arshisiddique1612]

@@NPT thanks for quick response, i will try and let you know

[@NPT]

@@arshisiddique1612 Yes, please let me know how it goes.

[@benchpolo]

can you use the @StartDate and @EndDate instead of the actual date?