Information Stewars Pros

[#1]

I have a table with the following entries:

VendorNumber VendorCountry VendorName AccountNumber
Ven1 VC1 VN1 ACCT1
Ven1 VC2 VN2

I have a requirement: if Vendor is in multiple countries, it is considered valid for all entries if it has a bank account number in at least 1 country for all entries, otherwise, blank or null entries for all countries for the same vendor are invalid.

for the scenario above Ven1 should be valid for both entries.

A basic if statement IF (AccountNumber is not NLL or AccountNumber !='') considers the first entry as valid, while the 2nd one is no

Adding (using the lookup)

If ($accountNumber is Null or $accountNumber =' ')
IF (VendorNumber = lookup ('Connection', 'table',
'AccountNumber', 'Is Not Null',
'AccountNumber', '!= \'\' ',
'VendorNumber', $VendorNumber) ) return True.

How would the 'IS NOT NULL' be treated: an actual string or a value? same for the !=\'\'.

If this does not work, any suggestions? I tried nested IFs, but was not able to get the desired output in the rule test.