Running SQL Queries from a Column.

[prakhar021]

Hello Mates, 
This is actually an urgent requirement I am actually quite close to the solution but I guess there something missing so looking on this community for help. 

Requirement - : You can refer the attached image for reference. Its a dummy data. I was able to get the query that in the SQL Query column also I was able to get rest of column. All I want is to run SQL Query that is mentioned in the last Column. And I want to generate the result of this query in another column. I tried with Dynamic Input tool combining it with batch macro but there is one or the other error I am getting. 

I would be really helpful I anyone could help me get the SQL query running and get the result in another column I have also attched the excel file so that  you can direct import into Alteryx.

All I want to find is the null count from the specific column in tables mentioned.  

[aatalai · Accepted solution]

@prakhar021 this should work (assuming they all use the same DCM connection, take a look and let me know how you get on 

[prakhar021]

Yes Its all tables in same datawarehouse so its same connection. One doubt, In the Macro, In input tool should I use the dummy query while making a connection in input tool ?

[aatalai]

Yes that should still be fine 

[prakhar021]

Thanks a lot its working !