topic Usage of "exists" in QlikView

Usage of "exists"

salto — Tue, 03 Aug 2010 19:06:16 GMT

Hello,

I am trying to check if the value of a field (CustomerID) in a table A is in any record of other table B, in the field PartnerID.

I am processing every record in table A. If the value of the CustomerID field can be found in table B, I'll update a field in table A.

I have tried with exists:

if(exists(CustomerID, PartnerID), "Yes","No") as CustomerIsPartner,

but QV cannot find PartnerID.

Should I go this way or can this be achieved with any other command?

Many thanks in advance.

Miguel_Angel_Baeyens — Tue, 03 Aug 2010 19:20:59 GMT

Hello,

You may use

LOAD PartnerID FROM FILE.QVD (qvd) WHERE EXISTS(CustomerID, PartnerID);

So the final table loaded will only contain those records where PartnerID matches with an already existing CustomerID.

Hope this helps!

johnw — Tue, 03 Aug 2010 20:22:29 GMT

I believe all you need to do is swap the field order and use single quotes:

if(exists(PartnerID, CustomerID),'Yes','No') as CustomerIsPartner

salto — Wed, 04 Aug 2010 08:49:00 GMT

Thank you, I'll have a look at the usage of .qvd files.

salto — Wed, 04 Aug 2010 08:50:15 GMT

Hello,

you were right, the order of the fields was incorrect. It works perfectly now!