topic Leading zero is removed in QlikView https://community.qlik.com/t5/QlikView/Leading-zero-is-removed/m-p/149511#M27681 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have this problem with leading zeros that are automatically removed from the input. I actually want the leading zeros to remain intact.</P><P>As an example script:</P><P>Test:<BR />load *;<BR />LOAD * INLINE [<BR />Code<BR />001<BR />01<BR />1<BR />002<BR />02<BR />2<BR />];</P><P>If I load this, it will only show me 2 rows (001 and 002), what I would like to see is: (001, 01, 1, 002, 02 and 2). Any suggestions?</P><P>The problem is actually from when I load data from an Oracle DB using ODBC, the above is just serving as an example <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P></BODY></HTML> Thu, 16 Jul 2009 20:59:53 GMT 2009-07-16T20:59:53Z Leading zero is removed https://community.qlik.com/t5/QlikView/Leading-zero-is-removed/m-p/149511#M27681 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have this problem with leading zeros that are automatically removed from the input. I actually want the leading zeros to remain intact.</P><P>As an example script:</P><P>Test:<BR />load *;<BR />LOAD * INLINE [<BR />Code<BR />001<BR />01<BR />1<BR />002<BR />02<BR />2<BR />];</P><P>If I load this, it will only show me 2 rows (001 and 002), what I would like to see is: (001, 01, 1, 002, 02 and 2). Any suggestions?</P><P>The problem is actually from when I load data from an Oracle DB using ODBC, the above is just serving as an example <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P></BODY></HTML> Thu, 16 Jul 2009 20:59:53 GMT https://community.qlik.com/t5/QlikView/Leading-zero-is-removed/m-p/149511#M27681 2009-07-16T20:59:53Z