Load Expression from excel and use them during load

[micheledenardi]

Hi guys,

i have two tables structured as below:

MAPPING_TABLE:

MapKey	MapFormula
a	Field1+Field2+Field3
b	Field1+Field2+Field3
c	Field1+Field2+Field3
d	Field1+Field2+Field3

FACT_TABLE:

Key	Field1	Field2	Field3
a	1	1	1
b	2	2	2
c	3	3	3
d	4	4	4

and i would like to use the declared formulas on this mapping table to obtain resulst on another table...so:

MAPPING_TABLE:
Mapping
Load
     MapKey,
     MapFormula

From MAPPING_TABLE.xls;

FACT_TABLE:
Load
     Key,
     Field1,
     Field2,
     Field3,
     Applymap('MAPPING_TABLE',Key) as Result
From FACT_TABLE.qvd(qvd);

but the resut is

Key	Result
a	Field1+Field2+Field3
b	Field1+Field2+Field3
c	Field1+Field2+Field3
d	Field1+Field2+Field3

and i would like to obtain:

Key	Result
a	3
b	6
c	9
d	12

Any idea ?

[joshrussin]

Are you trying to obtain a cumulative field from the mapping table?

[joshrussin]

look at these examples using just the data table, see if these help

[micheledenardi]

No,

i don't want to obtain a cumulative result.

I want to specify a formula (Ex. sum(Field1+Field2+Field3)) on the mapping table and then use applymap() to calculate the result of the formula by using the Field1, Field2, Field3 of my final table.