5 Replies Latest reply: Mar 19, 2014 3:42 PM by Staffan Johansson RSS

    Map multiple bandings in a single table

      Hi All,

       

      I have a table with a lot of numeric value fields, all of which need to be banded up into ranges (string).  I have had a look at IntervalMatch but I'm not certain it is what I want - at least I have not seen a useful example of my scenario.

       

      As an example:

      data:
      load * inline [
      A,B,C,D,E
      1,3,4,5,2
      10,3,20,3,2
      39,2,49,2,10];
      

       

      I now want to apply a banding to each of these fields.

       

      For A I want the banding to be:

      If >0 <= 5 then Low

      If >5 <=20 then Med

      If >20 then High

       

      For the others:

      IF >0 <=10 Low

      IF >10 High

       

      This is a simple example of what I'm trying to do, but to put it in context I have a table with about 50 fields I need to band and don't want to have to write IF THEN ELSE code for each one.

       

      Cheers,

       

      GPC