Lookup function

Fri, 05 Oct 2012 14:38:39 GMT

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);

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

Re: Lookup function

Fri, 05 Oct 2012 14:51:00 GMT

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