topic ApplyMap(HOW TO GET TRANSATION*CURRENCYRATE) in QlikView https://community.qlik.com/t5/QlikView/ApplyMap-HOW-TO-GET-TRANSATION-CURRENCYRATE/m-p/207661#M63335 <HTML><HEAD></HEAD><BODY><P><BR />tab1:<BR />currencycode,curecyrate<BR />EUR,0.8<BR />IND,0.4<BR />cad,5.2<BR /><BR />TAB2:<BR />vendocode,Currencycode, transamt<BR />111,CAD,700<BR />112,USD,900,<BR />113,UND,500<BR /><BR />in second table get the amount transamt* currencyrate value...using<BR />applymap..</P></BODY></HTML> Sat, 18 Sep 2010 06:41:55 GMT Anonymous 2010-09-18T06:41:55Z ApplyMap(HOW TO GET TRANSATION*CURRENCYRATE) https://community.qlik.com/t5/QlikView/ApplyMap-HOW-TO-GET-TRANSATION-CURRENCYRATE/m-p/207661#M63335 <HTML><HEAD></HEAD><BODY><P><BR />tab1:<BR />currencycode,curecyrate<BR />EUR,0.8<BR />IND,0.4<BR />cad,5.2<BR /><BR />TAB2:<BR />vendocode,Currencycode, transamt<BR />111,CAD,700<BR />112,USD,900,<BR />113,UND,500<BR /><BR />in second table get the amount transamt* currencyrate value...using<BR />applymap..</P></BODY></HTML> Sat, 18 Sep 2010 06:41:55 GMT https://community.qlik.com/t5/QlikView/ApplyMap-HOW-TO-GET-TRANSATION-CURRENCYRATE/m-p/207661#M63335 Anonymous 2010-09-18T06:41:55Z ApplyMap(HOW TO GET TRANSATION*CURRENCYRATE) https://community.qlik.com/t5/QlikView/ApplyMap-HOW-TO-GET-TRANSATION-CURRENCYRATE/m-p/207662#M63336 <HTML><HEAD></HEAD><BODY><P>Hi arunreddy <STRONG>,</STRONG></P><P>Check the attached example application</P><P></P><P style="font-weight: bold">tab1:</P><P style="font-weight: bold">mapping LOAD</P><P><B></B> <B>currencycode,</B></P><P style="font-weight: bold">currencyrate</P><P style="font-weight: bold">FROM</P><P style="font-weight: bold">Book1.xlsx</P><P style="font-weight: bold">(ooxml, embedded labels, table is tab1);</P><P style="font-weight: bold"><BR /></P><P style="font-weight: bold">tab2:</P><P style="font-weight: bold">LOAD vendercode,</P><P style="font-weight: bold">currencycode,</P><P style="font-weight: bold">transamt,</P><P style="font-weight: bold">applymap('tab1',currencycode) as currencyrate</P><P style="font-weight: bold">FROM</P><P style="font-weight: bold">Book1.xlsx</P><P style="font-weight: bold">(ooxml, embedded labels, table is tab2);</P><P></P><BR /><BR /></BODY></HTML> Sat, 18 Sep 2010 07:00:13 GMT https://community.qlik.com/t5/QlikView/ApplyMap-HOW-TO-GET-TRANSATION-CURRENCYRATE/m-p/207662#M63336 2010-09-18T07:00:13Z ApplyMap(HOW TO GET TRANSATION*CURRENCYRATE) https://community.qlik.com/t5/QlikView/ApplyMap-HOW-TO-GET-TRANSATION-CURRENCYRATE/m-p/207663#M63337 <HTML><HEAD></HEAD><BODY><P>Thanks <STRONG>nilupaboralessa.i get the result what you sent.</STRONG></P><P><STRONG>thanks for reply.<BR /></STRONG></P></BODY></HTML> Sat, 18 Sep 2010 07:35:07 GMT https://community.qlik.com/t5/QlikView/ApplyMap-HOW-TO-GET-TRANSATION-CURRENCYRATE/m-p/207663#M63337 Anonymous 2010-09-18T07:35:07Z