5 Replies Latest reply: Mar 13, 2014 11:52 AM by Udip Shrestha RSS

    Making Dynamic Mapping Tables

      Hello all,

       

      Any input will be appreciated

      I have a table where there are 3 column:

       

      RANK:

      ID          Brand     Rank

      1             a            1

      1             b            3

      1             c            2

      2             a            4

      2             b            7

      3             a            1

      3             b            5

       

      I was using this code:

      a_Ranking:

      Load *,

      Resident Rank

      where Brand = 'a';

       

      b_Rating:

      Load *,

      Resident Rank

      where Brand = 'b';

       

      c_Rating:

      Load *,

      Resident Rank

      where Brand = 'c';

       

      Therefore I was hardcoding and filtering the tables according to brand. Is there any way that I can make it dynamic? Let's say in the future they add new brand, the table will be generated automatically.

       

      Thanks.