2 Replies Latest reply: Dec 3, 2011 4:59 AM by Edward Hart RSS

    Make selections via expressions

      Hi,

       

      Im hoping somone would be able to advise me, I am currently building a model that uses several factors (I have about 10 tables containing these); I would like to build a generic spreadsheet for users to populate with key information.  The idea is that I load the spreadsheet into my ap, via expressions it will go through the spreadsheet and apply the figures that are relavent from the tables.

       

      Example

       

      Table 1

      Factor           ARange1     ARange2     Rate1

      A                    0               1000          1

      A                    1001          2000          2

      A                    2001          3000          3

      B                    0               1000          1

      B                   1001          2000           2

      B                    2001          3000          3

       

       

      Table2

      Factor          BRange        Rate2 

      A                 1                  2

      A                 2                  3

      B                 1                  1

      B                 2                   2

       

       

       

      User Generic Table

      Ref          Factor         ARange     BRange

      1             A               100            1

      2             B               800             1

      3             A               1750            2

      4             A                3000           2

       

       

       

       

      Required Table

      Ref          Factor        Rate1    Rate2

      1             A               1                2

      2             B               1               1

      3             A               2                3

      4             A               3               3

       

       

       

       

      I dont want to do this in the load script via joining tables;  is there anyway this can be done via an expression to select values from a table depending on other values?

       

       

       

      Many thanks