Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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