WHERE NOT EXISTS

[marina24]

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 · Accepted solution]

HI @marina24 

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]

It works!

 @MayilVahanan Thank you sooo much!

I really appreciate your help.

[MayilVahanan]

You're welcome