How to use sql #temp table and insert statement in qlik

ramkrishna86 — Tue, 21 Nov 2017 08:30:20 GMT

Hi,

Anyone have idea about sql #temp table and insert statement usability in qlik.

I have a sql query with multiple insert and #temp table, how to use this query in qlik.

Thanks,

Re: How to use sql #temp table and insert statement in qlik

jonathandienst — Tue, 21 Nov 2017 08:48:52 GMT

Just use the SQL keyword. The load will return no data but that is not a problem. For example

CONNECT ...

// create temp table (no data returned)

SQL

SELECT * into #temp

FROM mytable;

// do some manipulation to the temp table (no data returned)

SQL

UPDATE #temp

...

// Now get the data into QV

Table:

SQL SELECT * FROM #temp;

DISCONNECT; //#temp out of scope after disconnect, so the resources used are released

The #temp table remains in scope for the duration of a single database connection. Make sure that the connection has the necessary permissions to create temp tables.

topic Re: How to use sql #temp table and insert statement in qlik in App Development

How to use sql #temp table and insert statement in qlik

Re: How to use sql #temp table and insert statement in qlik