Multiple If condition for Data prep

[user36079]

Hi,

in my project I need to write the event type field in my XDM schema using data prep on source attribute.

The problem is that, the condition are multiple.

For example :

iif(statuscode == 'open' && status == 'option' && isPostponed == 'false', 'newoption', 'undefined')

In the same flow I have other condition to write the same event type field:

iif(statuscode == 'open' && status == 'optioned' && isPostponed == 'true', 'optionextended', 'undefined')

How can I write a single condition?

Thank you very much.

[Ankit_Chaudhary · Accepted solution]

Hi @user36079 

I haven't came across such use case yet, but you can try nesting the second iif condition into first one.

iif(
  statuscode == 'open' && status == 'option' && isPostponed == 'false',
  'newoption',
  iif(
    statuscode == 'open' && status == 'optioned' && isPostponed == 'true',
    'optionextended',
    'undefined'
  )
)