topic Re: How To Run Sql Temp Tables query in Qlikview? in QlikView

How To Run Sql Temp Tables query in Qlikview?

gireesh1216 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Please find my sql temp query and how to run this query in qlikview:

Example:

with Temp1

(

select * from Tab1

Temp2 as

(

select * from Temp1 A left join Tab2

Temp3 as

(

select * from Temp2 right join (select * from Tab3)

)

select * from Temp3 where Req_Id is null;

Re: How To Run Sql Temp Tables query in Qlikview?

Gysbert_Wassenaar — Tue, 13 Dec 2016 11:38:19 GMT

Create a working sql statement

Test it

Open Qlikview

Open the Script Editor

Create a connection to the database and insert the connection statement in the script

Paste the working sql statement in the script

Reload the document to execute the script and load the data into a table

Re: How To Run Sql Temp Tables query in Qlikview?

gireesh1216 — Tue, 13 Dec 2016 12:03:24 GMT

Hi Wassenaar

same sql query i ran in qlikview but getting "UNKNOWN STATEMENT" error

Re: How To Run Sql Temp Tables query in Qlikview?

Gysbert_Wassenaar — Tue, 13 Dec 2016 12:13:12 GMT

CONNECT OLEDB ...whatever ... ;

MyTable:

SQL

with Temp1

(

select * from Tab1

Temp2 as

(

select * from Temp1 A left join Tab2

Temp3 as

(

select * from Temp2 right join (select * from Tab3)

)

select * from Temp3 where Req_Id is null

;

And pray that whatever oledb or odbc driver you use supports the sql syntax you feed it.

Re: How To Run Sql Temp Tables query in Qlikview?

gireesh1216 — Tue, 13 Dec 2016 12:24:00 GMT

no not working... " with Temp1" hear with statement is not working in qlikview.

Re: How To Run Sql Temp Tables query in Qlikview?

Gysbert_Wassenaar — Tue, 13 Dec 2016 12:28:14 GMT

Qlikview doesn't understand any sql and won't try to execute it. Qlikview only sends it to the oledb or odbc driver you're using. If your driver doesn't understand it then you have to use sql that it does understand.

Re: How To Run Sql Temp Tables query in Qlikview?

gireesh1216 — Wed, 14 Dec 2016 05:26:45 GMT

Thanks Its running fine....