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


      Anon urgent1non urgentnon urgent
      Anon urgent2urgenturgent

      non urgent

      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!