Grabbing the output from a stored procedure

Question

I am able to run stored procedures pre/post SQL, etc and dynamically pass input parameters to them, but my question is, if I need to gain an output parameter as a result of running that procedure, how do I grab that output within Alteryx after running the proc in the post or pre-sql?

Thanks

ITG1 · Answer

Hi, thanks, I managed to be able to not need to grab any output after all by doing some manipulations on the data prior to load.  Thanks!

BrandonB · Answer

You could also use a Dynamic Input Tool if you need to dynamically pass different parameters as mentioned here: https://community.alteryx.com/t5/tkb/articleprintpage/tkb-id/knowledgebase/article-id/615

BrandonB · Answer

Can you use the stored procedure in the main query?