Dynamic SQL

[Santhosh_Sangar]

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

[rafalolbert · Accepted solution]

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.

Thanks,

Rafal

#Excuse me, do you speak Alteryx?