Force alternative answer with an applymap function

[#1]

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.

C

[swuehl · Accepted solution]

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

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