Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Dynamic SQL

Santhosh_Sangar
7 - Meteor
Hi All
I am running a query across a table with where condition as time frame.
Is there any way I can change the where clause time frame conditions automatically and run the sql every 1 hour with update time field

Example when it’s running at 1 PM the where clause in the query should be between 12 and 1 pm

Can anyone assist me if this is possible
1 REPLY 1
rafalolbert
11 - Bolide
11 - Bolide

Hi @Santhosh_Sangar,

 

Sure, this is possible - my recommendation is to use 'Replace a Specific String' in the 'Dynamic Input' tool to replace some placeholder with the exact string for the WHERE clause or its part.

 

image 1.JPG

 

Thanks,

Rafal

 

#Excuse me, do you speak Alteryx?

Labels