Create a custom SQL query by using the columns and filter conditions given in the excel

[KustumB]

Hi Alteryx community, 

I have a requirement to create a custom SQL query based on the list of columns and filter conditions given by the user in the excel sheet. Please find the example below. I have to generate a SQL query using Alteryx as select age, name, gender from employee table where age>30 and name = 'kust' and gender = 'F'. 

column names	Filter conditions
Age	age > 30
Name	name = 'kust'
Gender	gender = 'F'

Highly appreciate any help. Thanks in advance. 

[Felipe_Ribeir0]

Hi @KustumB 

You can adapt the attached workflow to do it

1)Use the dynamic input tool with a query looking at the table and with the filter values to be replaced:

2)Configure the replacement of the filters in the dynamic input tool:

[Felipe_Ribeir0]

Hi @KustumB 

It worked? If yes, please accept it as a solution. Thanks!