In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
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