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.

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