How to write if and if then else in Dataservices in the field level validation

Question

Hi Experts,

Any suggestions how to write the field Validation

if (Table.fieldname is not null and Table.fieldname <>'U')

if (table.fieldname is not null then EKKN.KNTTP

elseif(Table.fieldname is not null then

EKKN.GSEBR,'')

Answer 1

Rajan Burad Answered Apr 11 at 09:08 AM

0

Hello Ram,

Your requirement is not clear but still I tried to comprehend it.

Please try below code, using decode:

decode (Table.fieldname is not null and Table.fieldname <>'U', EKKN.GSEBR,

table.fieldname is not null, EKKN.KNTTP,

'' )

Let us know if it helps to achieve the requirement!

Thanks :)

Share

Comment

Find Questions & Answers