This content has been marked as final. Show 4 replies
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.