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!