topic Problem importing data fron an ODBC source.... in QlikView https://community.qlik.com/t5/QlikView/Problem-importing-data-fron-an-ODBC-source/m-p/168055#M39364 <HTML><HEAD></HEAD><BODY><P>Hello ...<BR />I'm importing our sales data through ODBC interface. I have items with code "08020"and the article code "8020", which are all seen with the code "08020", thereby distortingthe data revenue.<BR />How can I fix it??</P></BODY></HTML> Fri, 18 Mar 2011 09:28:25 GMT 2011-03-18T09:28:25Z Problem importing data fron an ODBC source.... https://community.qlik.com/t5/QlikView/Problem-importing-data-fron-an-ODBC-source/m-p/168055#M39364 <HTML><HEAD></HEAD><BODY><P>Hello ...<BR />I'm importing our sales data through ODBC interface. I have items with code "08020"and the article code "8020", which are all seen with the code "08020", thereby distortingthe data revenue.<BR />How can I fix it??</P></BODY></HTML> Fri, 18 Mar 2011 09:28:25 GMT https://community.qlik.com/t5/QlikView/Problem-importing-data-fron-an-ODBC-source/m-p/168055#M39364 2011-03-18T09:28:25Z Problem importing data fron an ODBC source.... https://community.qlik.com/t5/QlikView/Problem-importing-data-fron-an-ODBC-source/m-p/168056#M39365 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Use Text() function in the load script so it will respect leading zeroes:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Table:LOAD Text(Code) AS Code;SQL SELECT CodeFROM Datasource;</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope that helps.</P></BODY></HTML> Fri, 18 Mar 2011 09:30:58 GMT https://community.qlik.com/t5/QlikView/Problem-importing-data-fron-an-ODBC-source/m-p/168056#M39365 Miguel_Angel_Baeyens 2011-03-18T09:30:58Z Problem importing data fron an ODBC source.... https://community.qlik.com/t5/QlikView/Problem-importing-data-fron-an-ODBC-source/m-p/168057#M39366 <HTML><HEAD></HEAD><BODY><P>Ok!!! Everything's ok now. Thank's</P></BODY></HTML> Fri, 18 Mar 2011 15:51:16 GMT https://community.qlik.com/t5/QlikView/Problem-importing-data-fron-an-ODBC-source/m-p/168057#M39366 2011-03-18T15:51:16Z