Alteryx designer Discussions

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

Dynamic SQL

Highlighted
Meteoroid
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
Bolide
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