Variable calls variable in LOAD

Tue, 01 Jul 2014 21:39:44 GMT

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!

topic Variable calls variable in LOAD in QlikView