topic Re: Load Expression from excel and use them during load in App Development

Load Expression from excel and use them during load

micheledenardi — Wed, 13 Sep 2017 13:37:55 GMT

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 ?

Re: Load Expression from excel and use them during load

joshrussin — Wed, 13 Sep 2017 16:38:16 GMT

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

Re: Load Expression from excel and use them during load

joshrussin — Wed, 13 Sep 2017 17:05:38 GMT

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

Re: Load Expression from excel and use them during load

micheledenardi — Thu, 14 Sep 2017 14:14:47 GMT

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.