topic Re: WHERE NOT EXISTS in QlikView

WHERE NOT EXISTS

marina24 — Mon, 22 Mar 2021 15:48:00 GMT

Hi experts.

I want to do an incremental reload (INSERT & UPDATE).

«21.03.2021.xlsx» is old data.

«22.03.2021.xlsx» is new data.

[FULL]:
LOAD
ID,
TEXT,
DATE
FROM
[21032021.xlsx]
(ooxml, embedded labels);

STORE FULL into [FULL.qvd] (qvd);
DROP TABLE [FULL];

[DELTA&FULL]:
NoConcatenate
LOAD
ID,
TEXT,
DATE
FROM
[22032021.xlsx]
(ooxml, embedded labels)
Where DATE>= '22.03.2021';

Concatenate
LOAD
ID,
TEXT,
DATE
FROM
[FULL.qvd]
(qvd)
WHERE NOT EXISTS(ID);

STORE [DELTA&FULL] into [FULL.qvd] (qvd);

So QV displays only the first part of the text for each ID from old data.

Please help me.

MayilVahanan — Tue, 23 Mar 2021 08:26:38 GMT

Try like below

[DELTA&FULL]:
NoConcatenate
LOAD
ID,
ID as ID1,
TEXT,
DATE
FROM
[22032021.xlsx]
(ooxml, embedded labels)
Where DATE>= '22.03.2021';

Concatenate([DELTA&FULL])
LOAD
ID,
TEXT,
DATE
FROM
[FULL.qvd]
(qvd)
WHERE NOT EXISTS(ID1, ID);

DROP Field ID1;

marina24 — Tue, 23 Mar 2021 10:31:01 GMT

It works!

@MayilVahanan Thank you sooo much!

I really appreciate your help.

MayilVahanan — Wed, 24 Mar 2021 01:10:17 GMT

You're welcome