.. _given-then-else-snip: ====================== 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