We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Creating and executing a stored procedure in Alteryx

tahirlone
6 - Meteoroid

I have an SQL where which has 7 different variables that are to be dynamic in its WHERE and IN clause. 

Some of these variables are start_date, end_date (both have to be in string YYYYMMDD format), source_code, flag_value (Y or N) etc

 

I am trying to create a stored procedure inside Alteryx to help me run this query eventually using control parameters.

Can I create a stored procedure in Alteryx inside the PreSQL statements of my input tool to help me execute this query?

1 REPLY 1
apathetichell
20 - Arcturus

You'd call a stored procedure - but support for this is very odbc driver specific (ie SQL is a language - what DB are you using?). TBH - what you are trying to do can be done a variety of other ways in Alteryx...

Labels
Top Solution Authors