Execute Multiple SQL Queries and output to different tabs in excel

[psk009]

Hi,

Can anyone help me in this, I have a list of queries for a database and want to run them and result should be populated in different tabs of an excel workbook. 

Example:

select * from abc;

select * from xyz;

select * from ab23;

[RishiK]

@psk009 this link might help you:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-run-mutliple-SQL-statements-and...

An approach is as below:

[psk009]

Hi Rishi,

Thank you, but is there way to get the input dynamically for queries. 

I am connecting to Oracle database and my requirement is sometime i need to run 2-3 queries and some times 15-20 etc. 

[RishiK]

@psk009 you can via a query in the Input tool, Dynamic Input or via a stored proc. 

If you want to pass in parameters to the query then go down the stored proc route and call this via the dynamic input tool.

A few links that may be useful for you:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-To-Pass-Dynamic-Parameters-Fields-...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Execution-of-Stored-Procedures-using-I...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-Input-tool-Oracle-Stored-Proce...