Expression ... Handling multiple conditions

[former_member469694]

I am new in the MDM area and I have to write the expression to handle the following scenario

If country = US and Department code = ABC then either First name or Last name must be present. other wise error it out.

I have difficulty in handling multiple conditions.

Full points will be rewarded.

[Former Member]

Hi Mike,

Case1: Both Country and Departmentcode are Lookup tables

IF (Country AND Departmentcode , IS_NOT_NULL(FirstName) OR IS_NOT_NULL(LastName) , FALSE ) Within expression select Lookups -> Country. Countries list will be displayed and you can select any value from the list. Same for Departmentcode Case2: Country is lookup and Departmentcode is text field IF (Country AND Departmentcode='ABC' , IS_NOT_NULL(FirstName) OR IS_NOT_NULL(Lastname) , FALSE )

Regards,

Jitesh Talreja

[Former Member]

Hi,

I am assuming these are four fields in the main table:

country, Department code, First name and Last name

IF(FIND(country, "US") AND FIND(Department code, "ABC"), IS_NOT_NULL(First name) OR IS_NOT_NULL(Last name) , FALSE )

Hope it will Help you,

Rewards if Useful.....

Mandeep Saini