topic Error loading data in QlikView https://community.qlik.com/t5/QlikView/Error-loading-data/m-p/234025#M714739 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am having trouble with qlikview when loading a very specific set of data. For some strange reason, QV does not recognize "0E0" and "0E1" as different data values. When loading the following table, qv reads 5 records but only 4 distinct values.</P><P>this is the script:<I></I></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><I></I>T_Table:<BR />LOAD * INLINE [<BR />Field<BR />0E1<BR />0E0<BR />AAA<BR />BBB<BR />CCC];<I></I></PRE><BR /><BR /> <P>I would appreciate if anyone knows how to fix this.</P><P>Regards,</P><P>munirche</P><P></P></BODY></HTML> Mon, 11 Oct 2010 18:50:04 GMT munirche 2010-10-11T18:50:04Z Error loading data https://community.qlik.com/t5/QlikView/Error-loading-data/m-p/234025#M714739 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am having trouble with qlikview when loading a very specific set of data. For some strange reason, QV does not recognize "0E0" and "0E1" as different data values. When loading the following table, qv reads 5 records but only 4 distinct values.</P><P>this is the script:<I></I></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><I></I>T_Table:<BR />LOAD * INLINE [<BR />Field<BR />0E1<BR />0E0<BR />AAA<BR />BBB<BR />CCC];<I></I></PRE><BR /><BR /> <P>I would appreciate if anyone knows how to fix this.</P><P>Regards,</P><P>munirche</P><P></P></BODY></HTML> Mon, 11 Oct 2010 18:50:04 GMT https://community.qlik.com/t5/QlikView/Error-loading-data/m-p/234025#M714739 munirche 2010-10-11T18:50:04Z Error loading data https://community.qlik.com/t5/QlikView/Error-loading-data/m-p/234026#M714740 <HTML><HEAD></HEAD><BODY><P>That is weird. I can't say I know why it is happening.</P><P>To fix it, you should format the field as Text, use:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">T_Table:<BR />LOAD Text(Field) As Field INLINE [<BR /> Field<BR /> 0E1<BR /> 0E0<BR /> AAA<BR /> BBB<BR /> CCC<BR />];</PRE></BLOCKQUOTE><BR /><BR /> <P>EDIT: Could QlikView be treating it as scientific notation? 0 x 10^1 and 0 x 10^0 would both be zero?</P></BODY></HTML> Mon, 11 Oct 2010 19:09:38 GMT https://community.qlik.com/t5/QlikView/Error-loading-data/m-p/234026#M714740 2010-10-11T19:09:38Z Error loading data https://community.qlik.com/t5/QlikView/Error-loading-data/m-p/234027#M714741 <HTML><HEAD></HEAD><BODY><P>Your observation looks correct since =1E0*5 in QlikView equals 5 and QlikView treats 0A1 and 0A0 as distinct.</P></BODY></HTML> Mon, 11 Oct 2010 19:25:26 GMT https://community.qlik.com/t5/QlikView/Error-loading-data/m-p/234027#M714741 pover 2010-10-11T19:25:26Z Error loading data https://community.qlik.com/t5/QlikView/Error-loading-data/m-p/234028#M714742 <HTML><HEAD></HEAD><BODY><P>NMiller, thanks for your help.</P><P>Regards,</P><P>munirche</P></BODY></HTML> Mon, 11 Oct 2010 20:13:24 GMT https://community.qlik.com/t5/QlikView/Error-loading-data/m-p/234028#M714742 munirche 2010-10-11T20:13:24Z