topic SAP Connector problem automatiquely delete 0 in QlikView https://community.qlik.com/t5/QlikView/SAP-Connector-problem-automatiquely-delete-0/m-p/834773#M293693 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a problem on a request that I make directly into an Oracle database (I use the SAP connector).</P><P>I have&nbsp; one field Material and I have two different Materials is called :</P><P>07355606 and 7355606 I do not understand why QlikView removes the 0 automatiquely me before the 7 I find myself with two <SPAN style="font-size: 13.3333330154419px;">7355606</SPAN> Material.</P><P>Someone an idea?</P><P>Thank you.</P></BODY></HTML> Wed, 15 Apr 2015 06:01:25 GMT Anonymous 2015-04-15T06:01:25Z SAP Connector problem automatiquely delete 0 https://community.qlik.com/t5/QlikView/SAP-Connector-problem-automatiquely-delete-0/m-p/834773#M293693 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a problem on a request that I make directly into an Oracle database (I use the SAP connector).</P><P>I have&nbsp; one field Material and I have two different Materials is called :</P><P>07355606 and 7355606 I do not understand why QlikView removes the 0 automatiquely me before the 7 I find myself with two <SPAN style="font-size: 13.3333330154419px;">7355606</SPAN> Material.</P><P>Someone an idea?</P><P>Thank you.</P></BODY></HTML> Wed, 15 Apr 2015 06:01:25 GMT https://community.qlik.com/t5/QlikView/SAP-Connector-problem-automatiquely-delete-0/m-p/834773#M293693 Anonymous 2015-04-15T06:01:25Z Re: SAP Connector problem automatiquely delete 0 https://community.qlik.com/t5/QlikView/SAP-Connector-problem-automatiquely-delete-0/m-p/834774#M293694 <HTML><HEAD></HEAD><BODY><P>This is expected as QlikView decide to interpret this as a number, just use the text() Function so all entries are stored as String</P></BODY></HTML> Wed, 15 Apr 2015 08:23:48 GMT https://community.qlik.com/t5/QlikView/SAP-Connector-problem-automatiquely-delete-0/m-p/834774#M293694 2015-04-15T08:23:48Z