Force alternative answer with an applymap function

Tue, 21 Aug 2012 13:18:43 GMT

Hi,

I'm struggling with the applymap functionnality .

My script is as follows

applymapFOREX:

MAPPING LOAD

EUR, 0.7894

USD. 0.6514

FROM qvd;

applymap('applymapFOREX', Currency)

When applymap does not suceed in finding GBP, how can I force it to use the EUR amount?

Thanks in advance.

Re: Force alternative answer with an applymap function

swuehl — Tue, 21 Aug 2012 13:34:35 GMT

You could define a default expression as 3rd argument to applymap, so maybe

applymap('applymapFOREX', Currency, applymap('applymapFOREX','EUR'))