topic Create temporary table in SQL and insert values doesn't work in QLIikSense in App Development

Create temporary table in SQL and insert values doesn't work in QLIikSense

qlikmark1990 — Sat, 16 Nov 2024 06:54:24 GMT

For testing purposes I tried to create two temporary tables in A QLikSense script, written in SQL. My code is:

LIB CONNECT TO 'db02';

SQL

CREATE TABLE #A
(
    Nr int, 
    helft1 Varchar(1)
)

CREATE TABLE #B
(
    Nr int, 
    helft2 Varchar(1)
)

INSERT INTO #A VALUES (1, 'A')
INSERT INTO #A VALUES (2, 'B')
INSERT INTO #A VALUES (3, 'C')

INSERT INTO #B VALUES (4, 'D')
INSERT INTO #B VALUES (5, 'E')
INSERT INTO #B VALUES (6, 'F')

SELECT * FROM #A

SELECT * FROM #B

;

When I run the script I don't get any error messages:

Laden van gegevens gestart

Er worden verbinding gemaakt met db02
Verbonden
Zoekindex maken
Maken van zoekindex is voltooid

App opgeslagen

Voltooid
0 geforceerde fout(en)
0 synthetische sleutel(s)

My meaning is to create the two tables in SQL temporary and after querying this tables, get them in the model viewer of QLikSense. At the moment I don't get any data in my application. What am I doing wrong. My goal is to use SQL to manipulate and create tables instead of QLik-language.

Re: Create temporary table in SQL and insert values doesn't work in QLIikSense

jonathandienst — Tue, 08 Jan 2019 13:07:07 GMT

Most of this script looks OK to me, but I am not sure that Qliksense can use the two result sets returned. For testing, I would remove the second select * and see if QS get that data from a single select. I that works, then concatenate the two temp tables in the SQL select expression.

Re: Create temporary table in SQL and insert values doesn't work in QLIikSense

jonathandienst — Tue, 08 Jan 2019 13:08:58 GMT

I am of course assuming that the SQL syntax is correct for the DBMS. I would test the script in a query test tool (like SMS for SQL server, Toad or other).