Variable calls variable in LOAD

[#1]

Hi,

I am stuck with my variables but I am sure there is a simple answer that i d'ont see. If someone can help, it would be great!

In Excel source files, I have a master list of ID and Formulas.

In my script, I've created a variable for each ID. Each variable name is the ID.

Sourcefile:

ID       Formula

F01     Field1 + Field2

F02     Field1 * Field2

In this example, I got 2 variables then: F01 and F02.

In my script, I have a table for which , for each record, I have different fields and a field containing the ID of formula.

This table contains also the Field1 and Field2.

What I would like is to add to that table a column with the result of the formulas.

MyTable:

FieldA FieldB FieldC Field1 Field2 Formula

test1   bb       cc       10      15      F01

test2   bb       cc       10      15      F02

Should give me:

MyTable2:

FieldA FieldB FieldC Field1 Field2 Formula  Result

test1   bb       cc       10      15      F01         25

test2   bb       cc       10      15      F02         150

Any ideas?

Thanks!