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
Can you use the stored procedure in the main query?
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
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!
User | Count |
---|---|
107 | |
82 | |
72 | |
54 | |
40 |