Execute Multiple SQL Queries and output to different tabs in excel

Question

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;

rkapoor · Answer

@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-to-a-Stored-Procedure/td-p/87205

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Execution-of-Stored-Procedures-using-Input-Dynamic-Input-tool/td-p/518282

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-Input-tool-Oracle-Stored-Procedures/td-p/310312

psk009 · Answer

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.

rkapoor · Answer

@psk009 this link might help you:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-run-mutliple-SQL-statements-and-output-to-individual-tabs/td-p/427434

An approach is as below: