3 Replies Latest reply: May 30, 2017 9:49 PM by Lyn A RSS

    Mapping Range

    Lyn A

      Hi All!

       

      I would like to have some help regarding mapping ranges.

      Here is my Data:

      data:

      LOAD * INLINE [

      StudentID, Age

      1, 20

      2, 25

      3, 32

      4, 40

      5, 21

      ];

       

      agerangetable:

      LOAD * INLINE [

      SN, Age Range

      1, Below 21

      2, 21 to 24

      3, 25 to 29

      4, 30 to 35

      5, 36 to 39

      6, 40 and above

      ];

       

      I want to map the age range on my data table base on the student age, challenge is, the agerangetable is dynamic and changes when the user decides to change the range. Is there any way the user just change the agerangetable and when loaded, it will automatically change without me changing the logic? (ex. if(Age<21, 'Below 21' and so on)