Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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