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.
Solved! Go to 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.