topic Re: Alpha Content Converts to Numeric in QlikView https://community.qlik.com/t5/QlikView/Alpha-Content-Converts-to-Numeric/m-p/512695#M692358 <HTML><HEAD></HEAD><BODY><P>Try a text(FIELD), like in</P><P></P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; text(FIELD) as FIELD,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ...</P></BODY></HTML> Wed, 21 Aug 2013 15:07:07 GMT swuehl 2013-08-21T15:07:07Z Alpha Content Converts to Numeric https://community.qlik.com/t5/QlikView/Alpha-Content-Converts-to-Numeric/m-p/512694#M692357 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I'm encountering an issue during a load from an AS/400. The data type in the AS/400 for a Ship-to code is Alpha in many cases those codes can be numeric values however when loaded to QlikView I'm getting strange results. See chart below:<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 323px;"><TBODY><TR><TD class="xl64" height="17" width="161">As&nbsp; Represented in the AS400</TD><TD class="xl64" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="162">As Represented<BR />&nbsp; in QlikView</TD></TR><TR><TD class="xl65" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">1</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">00000001</TD></TR><TR><TD class="xl65" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">00000001</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">00000001</TD></TR></TBODY></TABLE><P>Any ideas on how to suppress this conversion and retain the original data representation?</P><P></P><P>Rich</P></BODY></HTML> Wed, 21 Aug 2013 15:01:42 GMT https://community.qlik.com/t5/QlikView/Alpha-Content-Converts-to-Numeric/m-p/512694#M692357 2013-08-21T15:01:42Z Re: Alpha Content Converts to Numeric https://community.qlik.com/t5/QlikView/Alpha-Content-Converts-to-Numeric/m-p/512695#M692358 <HTML><HEAD></HEAD><BODY><P>Try a text(FIELD), like in</P><P></P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; text(FIELD) as FIELD,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ...</P></BODY></HTML> Wed, 21 Aug 2013 15:07:07 GMT https://community.qlik.com/t5/QlikView/Alpha-Content-Converts-to-Numeric/m-p/512695#M692358 swuehl 2013-08-21T15:07:07Z Re: Alpha Content Converts to Numeric https://community.qlik.com/t5/QlikView/Alpha-Content-Converts-to-Numeric/m-p/512696#M692359 <HTML><HEAD></HEAD><BODY><P>Thank you.</P></BODY></HTML> Wed, 21 Aug 2013 19:28:52 GMT https://community.qlik.com/t5/QlikView/Alpha-Content-Converts-to-Numeric/m-p/512696#M692359 2013-08-21T19:28:52Z