Hello @maniruddha : as you mentioned, the Dynamic Input Tool is your friend! You first have to configure the Input Data Source Template with your query, then you can use the Modify SQL Query section to update specific values, or specific parts of the SQL string.
Hi @maniruddha : I could see a few approaches to this. The Dynamic Input tool only supports one replacement with groupings. Since you have two "in" conditions in the where statement, you could configure the tool to replace both but you will find that it runs very slow (row by row). My recommendation is to create the where condition and then replace the entire string in the Dynamic Input tool. I've attached a sample workflow of how you could build the where statement.
The attached workflow will build the where statement. Below are some sample screenshots of what the tool configuration would look like.
Sample Query Template
Select "Modify SQL Query", then "Replace a Specific String"
Ensure only the where statement is present in the "Text to Replace" and select the sql field for replacement.