Else¶

Sometimes you want conditional logic.

For example if gender is Female then do something else if Gender is Male do something else.

Rule Type Format¶

case when (logic) then “result” else “result” end

Snippits¶

Case Logic¶

Allows a a single levels of conditional logic or multiple levels

Single Level¶

Rule Type = Calculated Output Field

Rule Attribute = Rule Attribute = case when (Customer_Active=1) then ‘Active’ else ‘Not Active’ end : ActiveCustomerFlag

Multiple Levels¶

Rule Type = Calculated Output Field

Rule Attribute = case when (Person_Gender=1) then ‘F’ when (Person_Gender=2) then ‘M’ when (Person_Gender=3) then ‘U’ when (Person_Gender=4) then ‘X’ else ‘N’ end : Gender