cancel
Showing results for 
Search instead for 
Did you mean: 

tuple validation

Former Member
0 Kudos

Hi all,

I have created validations inside a tuple(multivalued).

I am not getting the results as expected.

1. can validations be performed on multivalued tuples....... are there any restrictions

2. I have 3 fields in tuple (division, phone 1, ext), my requirement is that if PHONE or EXT is not null, DIVISION is not null,

IF (IS NOT NULL(PHONE or EXT ), IS NOT NULL(DIVISION))

if I give only PHONE value and execute, the validation throws error..... works fine.

if I give only EXT, says no validation error.

pls guide me.

rgds,

ve

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks for your quick replies............ its working now.

rgds,

ve.

Former Member
0 Kudos

Hi Veena,

Try this :

IF(Is Not Null(Phone),Is Not Null(Division),IF(Is Not Null(Ext),Is Not Null(Division)))

Flow goes like If Phone is not null Division should not be null,and when Phone is null it checks if Ext is null in the Else part of expression.If Ext is not Null it imposes Division to be not null.

Hope it helps.

Thanks,

Ravi

Former Member
0 Kudos

Hi Veena,

Firstly, your expression is not correct, please use the below expression

IF (IS_NOT_NULL(PHONE) OR IS_NOT_NULL(EXT ), IS_NOT_NULL(DIVISION))

Kindly revert with result.

Regards,

Mandeep Saini