How To Run Sql Temp Tables query in Qlikview?

[gireesh1216]

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;

[Gysbert_Wassenaar]

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

[gireesh1216]

Hi Wassenaar

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

[Gysbert_Wassenaar · Accepted solution]

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.

[gireesh1216]

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

[Gysbert_Wassenaar]

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.

[gireesh1216]

Thanks Its running fine....