Given > Then > 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