Using SQL's WHERE NOT EXISTS in qlik sense Script

[RK01923683]

Dear Experts,

I wanted to extract the data that not exists in other table. I am using this SQL Script:

Select a.ID
,a.LocId as StartLoc
,a.Date as BeginTime
from source as a
where a.Type = 'I'
a.Date between 'date1' and 'date2'
and a.LocId = 54
and not exists
(select * from source as c
where a.ID = C.ID
and where c.Type in ('O')
and a.Date < c.Date
and c.Date between 'date1' and 'date2')

i don't know how to create the same logic in qlik script i am not understanding how to do the not exist part.

Please help!

Thanks in advance

[NadiaB]

Hi RK01923683

As long as you have a connection to the database the script should work:

https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularSt...

<CONNECTION>

SQL Select column from table where condition=value;

It just has to be a valid SQL statement. 

Hope it helps.