Execute a SQL query generated dynamically within Alteryx

[Biswarun]

I have a configuration table in MS SQL Server (local). Based on values of certain columns in that table, I need to load data from another table in the same server.

So, I read in the configuration table via the input tool. Then, I used the formula tool of Alteryx to produce a SQL query string in a new column. This string is nothing fancy and will ALWAYS reduce to "SELECT * FROM [Variable] WHERE [VARIABLE]". Now, how to execute this query?

I am new to blending Alteryx with DB and will appreciate help.

[Biswarun · Accepted solution]

Ah - the good old dynamic input tool came to my rescue. Threw in a dummy query and replaced the entire query from my column.