How to access CTE table from PostgreSQL to Qlik data load editor?

[Vikash938]

I have one CTE (common expression table) table in PostgreSQl database. I want to access that CTE table in data load editor. how to do that?

[Levi_Turner]

Make sure to enable non select queries on the data connection:

But here's a sample which you can use for reference:

LIB CONNECT TO 'PostgreSQL';
LOAD *;
SQL WITH cte1 (temp_var1, temp_var2) AS (
VALUES
(1,4),
(2,5),
(3,6)
)
SELECT 
temp_var1
, temp_var2
, (temp_var1 + temp_var2) AS temp_var3
FROM cte1; 

[Vikash938]

@Levi_Turner  can you little bit more? I didn't get it right now.