0 Replies Latest reply: Jul 1, 2014 5:39 PM by Caroline Massin RSS

    Variable calls variable in LOAD

      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!