topic Data changing on load in QlikView

Data changing on load

Fri, 18 Sep 2009 02:29:04 GMT

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!

Data changing on load

prieper — Fri, 18 Sep 2009 02:51:15 GMT

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

Peter

Data changing on load

Fri, 18 Sep 2009 02:54:58 GMT

Peter,

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

Data changing on load

biester — Fri, 18 Sep 2009 02:58:36 GMT

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

Rgds,
Joachim

Data changing on load

Fri, 18 Sep 2009 03:05:34 GMT

Thank you Joachim!