5 Replies Latest reply: Apr 2, 2014 7:58 AM by Erik Furlanis RSS

    populate a field based on values of two different fields

      Dear all,

       

      I have the following, for which I cannot decide the best method how to tackle this

       

      Basically, the first four columns is the scenario and the fifth one, outcome, is the outcome I plan to get

       

      CustomerCust_categoryOrderOrder_categoryOUTCOME
      Anon urgent1non urgentnon urgent
      Anon urgent2urgenturgent
      Burgent3

      non urgent

      urgent
      Curgent4urgenturgent
      Curgent5non urgenturgent
      Dnon urgent6non urgentnon urgent

       

      Shall I achieve this by doing two resident loads?

      first, loading the 4 columns and generating the Outcome column?

      and then reloading this data, and if (outcome=non urgent) but customer=urgent, assign the urgent flag?

       

      Or, is there a better way?

      thank you!