Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

Data changing on load

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!

Tags (1)
1 Solution

Accepted Solutions
biester
Valued Contributor

Data changing on load

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

Rgds,
Joachim

4 Replies
prieper
Honored Contributor II

Data changing on load

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

Peter

Not applicable

Data changing on load

Peter,

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

biester
Valued Contributor

Data changing on load

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

Rgds,
Joachim

Not applicable

Data changing on load

Thank you Joachim!