topic Country code varchar2 issue in QlikView https://community.qlik.com/t5/QlikView/Country-code-varchar2-issue/m-p/1109381#M902840 <HTML><HEAD></HEAD><BODY><P>Team</P><P>&nbsp;&nbsp; I am having two table one for country and client transaction, they kept the country code as varchar2 at oracle. I could not able to match the values based on country code.</P><P></P><P>country</P><P>country_code - varchar2</P><P>country_name - char</P><P></P><P>client_transaction</P><P>client_id&nbsp; - Number</P><P>Amount&nbsp; - Number</P><P>country_code - varchar2</P><P></P><P></P><P>Can any one suggest me how can&nbsp; we convert the varchar2 to character in qlikview to match the codes</P><P></P><P>country code&nbsp; details</P><P>MEX</P><P>ARG</P><P>USA</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Country code varchar2 issue https://community.qlik.com/t5/QlikView/Country-code-varchar2-issue/m-p/1109381#M902840 <HTML><HEAD></HEAD><BODY><P>Team</P><P>&nbsp;&nbsp; I am having two table one for country and client transaction, they kept the country code as varchar2 at oracle. I could not able to match the values based on country code.</P><P></P><P>country</P><P>country_code - varchar2</P><P>country_name - char</P><P></P><P>client_transaction</P><P>client_id&nbsp; - Number</P><P>Amount&nbsp; - Number</P><P>country_code - varchar2</P><P></P><P></P><P>Can any one suggest me how can&nbsp; we convert the varchar2 to character in qlikview to match the codes</P><P></P><P>country code&nbsp; details</P><P>MEX</P><P>ARG</P><P>USA</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Country-code-varchar2-issue/m-p/1109381#M902840 2020-11-25T16:16:04Z Re: Country code varchar2 issue https://community.qlik.com/t5/QlikView/Country-code-varchar2-issue/m-p/1109382#M902841 <HTML><HEAD></HEAD><BODY><P>try using to_char() in the SQL SELECT script and trim() function in the LOAD script</P></BODY></HTML> Thu, 07 Jul 2016 15:10:22 GMT https://community.qlik.com/t5/QlikView/Country-code-varchar2-issue/m-p/1109382#M902841 boorgura 2016-07-07T15:10:22Z