Lookup function

[#1]

Hi,

I have the following exchange rate table that is loaded using;

currency_rate:

Mapping LOAD Currency,

     Rate

FROM [_indata\rates.xls] (biff, embedded labels);

Currency	Rate
CHF	1.0560
EUR	1.2657
RMB	0.1583
SEK	0.1398
USD	1

I want to multiple a price with the applible EUR Rate but the script below doesn't return any data.

Price_Data:

LOAD [Part Number] as part_key,

     [SAP Standard Price],

     [SAP Standard Price]*lookup('Rate','Currency','EUR','currency_rate') as [SAP Standard Price $],

...

How do I write the script to get the desired [SAP Standard Price $]?

Best regards,

Jonas

[#2 · Accepted solution]

The following code worked;

Price_Data:

LOAD [Part Number] as part_key,

     [SAP Standard Price],

     [SAP Standard Price]*ApplyMap('currency_rate','EUR') as [SAP Standard Price $],

...

Best regards,

Jonas