Loop through SQL queries in an excel file to fetch data from a SQL database

I'm new to Alteryx!

Having said that, i'm in a situation where i have an excel file (.xlsx) with 10-20 SQL queries to be executed to fetch data from a SQL database and produce separate excel outputs for each query results. Below is an example of the sql query i the excel file :

Select top 10 'def' as 'DEF', CRP as 'Entity', ACCT, ADJ form CTXAMT_2018

I'm also attaching a screenshot of my approach. But, i am stuck in how to make it loop through all the SQL queries.

batch macro.jpg

Appreciate your help.

Thanks.

Macros

Accepted answers

LordNeilLord

Yay!!

I'm glad we got there

Do you usually find connecting to your database through alteryx is slow?

I also notice that you are using OLEDB to connect, can you use ODBC instead?

Alternatively yes! Try the Dynamic Input InDB and see if that makes a difference

All comments

LordNeilLord

Hey @Bhavika

You'll need to make this a batch macro and have your output tool within the macro.

Something like this:

SQLLoop.yxzp

Bhavika

Hey,

Thank you so much for your reply. But unfortunately, my organization has Alteryx designer 11.0 and so i'm unable to open the alteryx package you shared.

Can you please help me with any screenshots depicting the way you've configured the tools. Alternatively, is there a way i can open the package in my version of alteryx.

Appreciate your help.

LordNeilLord

Try this:

SQLLoopv11.yxzp

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235