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.
SOLVED

Using constant in output tool presql statement

HMSUM
7 - Meteor

Is it possible / any workaround to pass an Alteryx workflow constant to pre sql statement .

 

HMSUM_0-1621481290268.png

 

HMSUM_1-1621481324213.png

 

For example I want to pass the "Date" parameter into the SQL statement

 

 

1 REPLY 1
apathetichell
20 - Arcturus

You can put the output data in a batch macro and feed in your value via the control parameter - you can then use an action tool to update the pre-sql part of the output data.

 

The attached is a base outline of how to do it. This is is a boiler plate version which you'll have to adapt to your needs - but the idea works for your needs.

2021-05-19 (1).png

Labels
Top Solution Authors