Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
Just use the SQL keyword. The load will return no data but that is not a problem. For example
// create temp table (no data returned)
SELECT * into #temp
// do some manipulation to the temp table (no data returned)
// Now get the data into QV
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.