Passing Queries to Run in a DB via Input File

[AndrewS197]

Hello,

I'm new to this so forgive me if this is a silly question. I'm trying to figure out if it's possible to take a series of queries stored in a text file / excel file, input them into Alteryx and somehow run those queries against a database to spit out the output somehow? I basically am wanting to allow a team to save batch of queries to a file and then schedule a workflow to pick them up, run them, and then spit the output out to the team so that it can all be ready to go in the morning.

I'm working with IBM DB2.

Any ideas?

[Felipe_Ribeir0]

Hi @AndrewS197 

Yes, it is possible. Take a look at this topic: Solved: Re: Read and Execute .sql file - Alteryx Community

You can use the input tool to connect to the txt file, read the query and pass it to a dynamic input tool: