topic Re: Where Not Exists... Sort of.... in QlikView

Where Not Exists... Sort of....

prees959 — Wed, 20 Nov 2019 16:18:30 GMT

Hi ,

I have an existing table that I am loading in:

RefNo
840420110602
840420110619
840420110664
840420110671
840420110688
840420110695
840420110701
840420110718

I then load in a new batch of codes :

RefNo
840420110602
840420110619
840420110664
840420110671
840420110688
840420110695
840420110701
840420110718
840420110725
840420110732
840420110749
840420110756
840420110763

I need to be only left with :

840420110725

840420110732

840420110749

840420110756

840420110763

As I need to run these through a check process. Can anyone assist with the correct script for this please?

Many thanks,

Phil

Re: Where Not Exists... Sort of....

Vegar — Wed, 20 Nov 2019 18:08:46 GMT

What do you mean by "sort of...."

Your example looks like it could be solved by just a where not exsists Like below. Please explain.

OldRefs:

Load

RefNo as exsistingRefNo

From table1;

NewRefs:

Load

RefNo

From table1

Where not exsists(exsistingRefNo, RefNo);

Drop table OldRefs;

Re: Where Not Exists... Sort of....

Brett_Bleess — Wed, 04 Dec 2019 19:25:31 GMT

Phil, did Vegar's post help you get what you needed? If so, do not forget to return to the thread and use the Accept as Solution button on his post to give him credit for the assistance and to let other Community Members know this worked for you. If you still have further questions etc., leave us an update.

Regards,
Brett