implicit conversion varchar to number

[#1]

I have in my data base a varchar filed which contain a product code ('000004'). Qlikview diplay this field as a number format (right position) and the field which start with '0' are truncate if it conntain more 4 '0'.

As result i get two codes for the same product!

Code Date base Code QliK view

'0000027' ' 00027'

'00027' '00027'

[#2]

Hi,

You can use the Text function for this implicit conversion in script while loading the data, which will be as under:-

Text([Product Code]) AS [Product Docde]

Please revert back for any futher query.

[#3]

Thank you very much! Its working now 🙂