Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Why lose zero when convert string to big decimal

Hello,

I have a probleme with convertion String.
In fact i would like to convert a string 022451547.
The result with method "new BigDecimal" is 22451547. I lose a zero in begin.
I search in google and talend forum but I have not found.
Have you a solution ?
Thanks in advance,

Labels (2)
1 Reply
cterenzi
Specialist
Specialist

Leading zeroes are not stored in numeric data types.  If you need them for display purposes, there are formatting functions you can use, but if you need them for comparison purposes, you'll have to stick to strings.