How should I assign the fractional part to a BigDecimal that comes from a tFileInputPositional in Talend?
I’m working with Talend Open Studio for Data Integration.
I’ve got a tFileInputPositional which creates several fields. One of them would look like this: “+0000030139808303”.
I need to save those fields into a BigDecimal(20,2) so that the last two digits would be the fractional part but, when typing it in the component’s schema, it simply adds “,00” at the end of the number.
So, summing up…
What I have:
What I want:
What I get:
Could anyone help me to make it work?
I suspect you just want
Returns a BigDecimal which is equivalent to this one with the decimal point moved
nplaces to the left. If
nis non-negative, the call merely adds
nto the scale. If
nis negative, the call is equivalent to
BigDecimalreturned by this call has value
(this × 10^-n)and scale