Data changing on load

[#1]

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!

[prieper]

Please use the TEXT()-function, this should do.

Peter

[#3]

Peter,

Thanks for your response. I have tried the TEXT() function and get a SQL error each time. Any other suggestions?

[biester · Accepted solution]

Use the TEXT() function in the LOAD statement, NOT in the SQL statement.

Rgds,
Joachim

[#5]

Thank you Joachim!