6 Replies Latest reply: May 15, 2014 10:07 AM by adonis _ RSS

    Create mapping values

    adonis _

      what is the easiest way to substitute a value ie:

       

      If i have a set of values:

      01

      02

      03

      07

      01c

      02c 

      07k

       

      and i want to change them to either Buy or Sell based on value

      code

      01 = Buy

      02 = Sell

      03 = Buy

      07 = Sell

      01c = Buy

      02c = Sell

      07k = Sell

       

      it is not like in access i can do a simple mapping table and point the value matching code  and spit out field called buy/sell and the appropriate values come out.

       

      please let me know