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:

      load * inline [


      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.