ApplyMap(HOW TO GET TRANSATION*CURRENCYRATE)

[Anonymous]

tab1:
currencycode,curecyrate
EUR,0.8
IND,0.4
cad,5.2

TAB2:
vendocode,Currencycode, transamt
111,CAD,700
112,USD,900,
113,UND,500

in second table get the amount transamt* currencyrate value...using
applymap..

[#2 · Accepted solution]

Hi arunreddy ,

Check the attached example application

tab1:

mapping LOAD

currencycode,

currencyrate

FROM

Book1.xlsx

(ooxml, embedded labels, table is tab1);

tab2:

LOAD vendercode,

currencycode,

transamt,

applymap('tab1',currencycode) as currencyrate

FROM

Book1.xlsx

(ooxml, embedded labels, table is tab2);

[Anonymous]

Thanks nilupaboralessa.i get the result what you sent.

thanks for reply.