4 Replies Latest reply: Sep 17, 2009 11:05 PM by mhennigan RSS

    Data changing on load

    mhennigan

      I am loading barcode information from a mySQL database. The field is set up as a varchar(13). I have noticed that once the data is loaded into QlikView, several barcodes that have leading zeros in mySQL no longer have them in QlikView. (Ex: original barcode in mySQL=047357; this barcode in Qlikview=47357). Is there a reason why I am losing this leading zero and is there any way to prevent this going forward?

      Any information would be greatly appreciated!