topic Re: pls clarify this issue? in QlikView https://community.qlik.com/t5/QlikView/pls-clarify-this-issue/m-p/576526#M1116947 <HTML><HEAD></HEAD><BODY><P>use your table 2 as Map table</P><P></P><P>and use applymap() in Table 1 to correct / modify the country names... it will work</P></BODY></HTML> Wed, 12 Feb 2014 20:51:57 GMT 2014-02-12T20:51:57Z pls clarify this issue? https://community.qlik.com/t5/QlikView/pls-clarify-this-issue/m-p/576525#M1116946 <HTML><HEAD></HEAD><BODY><P>tab1:</P><P>load * inline</P><P>[</P><P>country,state</P><P>unitedstate of america,america</P><P>india,andhra</P><P>pakisthan,oekisthan</P><P>];</P><P></P><P></P><P></P><P></P><P>tab2:</P><P></P><P></P><P>load * Inline</P><P>[</P><P>country, shcountry&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P> india,in,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --i want&nbsp; replace name instead of India,in</P><P>pakisthan-pak&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----- here i want rename. </P><P>unitedstate of america,usa,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HOW TO DO THIS IF I WRITE RESIDENT ITS GIVING ERROR</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">];</SPAN></P></BODY></HTML> Wed, 12 Feb 2014 15:45:37 GMT https://community.qlik.com/t5/QlikView/pls-clarify-this-issue/m-p/576525#M1116946 2014-02-12T15:45:37Z Re: pls clarify this issue? https://community.qlik.com/t5/QlikView/pls-clarify-this-issue/m-p/576526#M1116947 <HTML><HEAD></HEAD><BODY><P>use your table 2 as Map table</P><P></P><P>and use applymap() in Table 1 to correct / modify the country names... it will work</P></BODY></HTML> Wed, 12 Feb 2014 20:51:57 GMT https://community.qlik.com/t5/QlikView/pls-clarify-this-issue/m-p/576526#M1116947 2014-02-12T20:51:57Z