topic Re: Where NOT IN clause in LOAD statement in QlikView

Where NOT IN clause in LOAD statement

Wed, 25 Nov 2020 16:16:04 GMT

Good morning,

I have the following two tables:

TAB1

TAB2

I need to load all records from TAB1 where rows are not in TAB2. With a sql statement i should do this

select * from TAB1 where ID1 not in (select ID2 from TAB2)

But with LOAD statement how could i do?

sunny_talwar — Tue, 10 Oct 2017 17:03:33 GMT

May be this

Table:

LOAD ID1

FROM TAB1;

Concatenate (Table)

LOAD ID2 as ID1

FROM Tab2

Where not Exists(ID1, ID2);

its_anandrjs — Tue, 10 Oct 2017 17:19:40 GMT

Try with

TAB2:

LOAD ID2

From Source;

TAB1:

LOAD ID1

From Source Where not Exists(ID2,ID1);

//IF TAB2 not required you can drop it

Drop Table TAB2;

Wed, 11 Oct 2017 07:20:41 GMT

Thanks Anand,

that's the right solution.

Thank you all