How to connect .sql file with text input tool in Alteryx Designer

Question

Hi Team,

i m trying to understand one workflow,that contains multiple .sql files connected through Text input Tool.

Please help me to understand:

1. How can i connect .sql file with Text Input Tool.

I tried to selecting/brows .Sql file via. Text input tool,but error is coming like " sql file not found".

I already refer several links, (like below) ,but no luck.

Link:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connect-to-a-SQL-file/td-p/154596

In addition with above..

Please let me know ,can we connect multilple .sql file using text input tool?

My workflow is like below:

Multiple. Sql files connected through text input tool then output of text input tool connected to different macros as per no.of different .sql files.

Ex.:  5 Macros for 5 .sql files.

Please help me to understand the logic.

Regards

Piyush J

BrandonB · Answer

Hi @PiyushJain

If you need to dynamically read in queries you will need to use the dynamic input tool: https://help.alteryx.com/current/designer/dynamic-input-tool

This tool can read in a query or values and execute those changes on runtime.

Alternatively you may need to use a macro if you have changing schemas in the same input.

PiyushJain · Answer

Hi Team,

Please reply..

Regards

Piyush J

PiyushJain · Answer

Hi Brandon,

As per my workflow,

I am looking to actually execute the query through text input tool. ( as seems the workflow doing the same).

Because these sql queries ( as output of text input tool) are connected to different macros and then connected with different other tools like summarize.

Unfortunately i m not able to run complete workflow because macros are encrypted.

So trying to understand workflow step by step.

And the first step is:  How .sql queries are connected to text input tool and proceed.

Please let me know if you need more details.

Regards

Piyush J