Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Use the TEXT() function in the LOAD statement, NOT in the SQL statement.
Rgds,
Joachim
Please use the TEXT()-function, this should do.
Peter
Peter,
Thanks for your response. I have tried the TEXT() function and get a SQL error each time. Any other suggestions?
Use the TEXT() function in the LOAD statement, NOT in the SQL statement.
Rgds,
Joachim
Thank you Joachim!