Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Grabbing the output from a stored procedure

ITG1
7 - Meteor

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

3 REPLIES 3
BrandonB
Alteryx
Alteryx

Can you use the stored procedure in the main query? 

BrandonB
Alteryx
Alteryx

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 

ITG1
7 - Meteor

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!

Labels
Top Solution Authors