Read and Execute .sql file

Devaraj_Manimaran

Hello All,

Please help with this.

I have a .sql file where i have sql query. i connected to oracle db, but for now i can only copy paste the query directly into the table or query tab. how do i direct a path of my sql file, where it should read the sql query inside it and execute as output.

Workflow

Database Connection

Accepted answers

Swap from "Read list of data sources" to modify "SQL query" (the lower radio button). Use your field as your query.

Hi @Devaraj_Manimaran

Check the attached workflow

1)I am reading the query with the input tool

2)I used the summarize tool to turn it all in 1 cell

3)I used the bellow config to replace the embedded query of the dynamic tool for the one that came from the summarize tool

New Workflow2.yxzp

All comments

Hi @Devaraj_Manimaran

You can use the input tool to read the query and the dynamic input tool to execute it.

Solved: Connect to a .SQL file - Alteryx Community

Devaraj_Manimaran

I did as you said. but please find the below screenshots, i have error saying no tables chosen. should i change something?

Swap from "Read list of data sources" to modify "SQL query" (the lower radio button). Use your field as your query.

Hi @Devaraj_Manimaran

Check the attached workflow

1)I am reading the query with the input tool

2)I used the summarize tool to turn it all in 1 cell

3)I used the bellow config to replace the embedded query of the dynamic tool for the one that came from the summarize tool

New Workflow2.yxzp

Devaraj_Manimaran

Thanks, now it makes sense. 😊

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703