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
