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;
@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:
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.
@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/87205https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Execution-of-Stored-Procedures-using-Input-Dynamic-Input-tool/td-p/518282https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-Input-tool-Oracle-Stored-Procedures/td-p/310312
