topic Re: mapping table in QlikView https://community.qlik.com/t5/QlikView/mapping-table/m-p/622430#M478099 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>MapTable:</P><P>Mapping</P><P>Load Value,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Map To Value</P><P>from Mapping Table2.xlsx ...</P><P></P><P>LOAD *, ApplyMap('MapTable, Value) as MappedValue</P><P>....</P><P></P><P>Regards,</P><P>David</P></BODY></HTML> Wed, 26 Mar 2014 09:24:40 GMT daveamz 2014-03-26T09:24:40Z mapping table https://community.qlik.com/t5/QlikView/mapping-table/m-p/622429#M478098 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a mapping table that I would like to map some values (which are in another table) to. Any suggestions on the best way?</P><P></P><P>Thank you Herbert</P></BODY></HTML> Wed, 26 Mar 2014 09:20:50 GMT https://community.qlik.com/t5/QlikView/mapping-table/m-p/622429#M478098 2014-03-26T09:20:50Z Re: mapping table https://community.qlik.com/t5/QlikView/mapping-table/m-p/622430#M478099 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>MapTable:</P><P>Mapping</P><P>Load Value,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Map To Value</P><P>from Mapping Table2.xlsx ...</P><P></P><P>LOAD *, ApplyMap('MapTable, Value) as MappedValue</P><P>....</P><P></P><P>Regards,</P><P>David</P></BODY></HTML> Wed, 26 Mar 2014 09:24:40 GMT https://community.qlik.com/t5/QlikView/mapping-table/m-p/622430#M478099 daveamz 2014-03-26T09:24:40Z Re: mapping table https://community.qlik.com/t5/QlikView/mapping-table/m-p/622431#M478100 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>you can try</P><P> </P><P><SPAN style="color: #000000;">ValueMap:</SPAN> </P><P><SPAN style="color: #000000;">mapping load </SPAN></P><P>Value,</P><P>MapValue</P><P>From&nbsp; XXX;</P><P></P><P>then on the Main table for the field.</P><P>Data:</P><P>Load</P><P>value,</P><P>ApplyMap('<SPAN style="color: #000000;">ValueMap</SPAN>',Value) as MapValue</P><P>From XXX2</P><P>or resident&nbsp; XXXX2</P><P></P><P>thanks</P><P>Michael</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P> </P></BODY></HTML> Wed, 26 Mar 2014 09:30:10 GMT https://community.qlik.com/t5/QlikView/mapping-table/m-p/622431#M478100 2014-03-26T09:30:10Z Re: mapping table https://community.qlik.com/t5/QlikView/mapping-table/m-p/622432#M478101 <HTML><HEAD></HEAD><BODY><P>Thank you</P></BODY></HTML> Wed, 26 Mar 2014 09:33:18 GMT https://community.qlik.com/t5/QlikView/mapping-table/m-p/622432#M478101 2014-03-26T09:33:18Z Re: mapping table https://community.qlik.com/t5/QlikView/mapping-table/m-p/622433#M478102 <HTML><HEAD></HEAD><BODY><P>cool anytime...<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 26 Mar 2014 09:35:27 GMT https://community.qlik.com/t5/QlikView/mapping-table/m-p/622433#M478102 2014-03-26T09:35:27Z