multiple SQL lines (; ) in Qlik Script

mohedano — Wed, 28 Jul 2021 21:29:31 GMT

hi all,

I'm trying to run a SQL statement that creates a few TEMP tables and then applies some joins to those tables.

The query runs just fine in the IDE but when running it in Qlik Sense script, the reload fails. the reason is that the query contains multiple semicolons (;), indicating the end of the SQL, or at least that's what Qlik thinks and ignoring the rest of the SQL, causing a syntax error at the reload time.

here's a simplified version of the SQl I'm trying to run in qlik:

CREATE TEMP TABLE Eng as (

select distinct FIELD_A
from SCHEMA.fact_table

); // first semicolon

CREATE TEMP TABLE phone_calls as (

SELECT das.*
FROM SCHEMA.fact_table_TWO das
); // second semicolon

select *
from Eng
left join phone_calls on phone_calls.key_field_1 = Eng.key_field_2
; // last semicolon

thank you all!

Re: multiple SQL lines (; ) in Qlik Script

MayilVahanan — Thu, 29 Jul 2021 06:49:43 GMT

Create statement won't work in Qliksense.

CREATE TEMP TABLE Eng as (

select distinct FIELD_A
from SCHEMA.fact_table

);

instead of this, try like below

FactTabletemp:

select distinct FIELD_A
from SCHEMA.fact_table;

FactTabletemp <-- this table contains the distinct values from fieldA

Hope its helps you

topic multiple SQL lines (; ) in Qlik Script in Connectivity & Data Prep

multiple SQL lines (; ) in Qlik Script

Re: multiple SQL lines (; ) in Qlik Script