topic Re: Cannot Convert from Float to BigDecimal Error: Tried with java syntax new BigDecimal. in Talend Studio

Cannot Convert from Float to BigDecimal Error: Tried with java syntax new BigDecimal.

Anonymous — Tue, 03 Oct 2017 13:21:27 GMT

Hi All,

I have got this error while loading data, I tried with java syntax new BigDecimal: Kindly help me.

Error: Cannot Convert from float to BigDecimal.

Talend Team Please comment on this.

Re: Cannot Convert from Float to BigDecimal Error: Tried with java syntax new BigDecimal.

Anonymous — Tue, 03 Oct 2017 14:58:33 GMT

I'm not sure the error is happening where you think it is. Perhaps switch to the code view and see more info on where it's happening.

Also, converting from a float to a BigDecimal isn't perfect since float is not an exact numeric. You may want to consider rounding to specific number of digits to get more exact. What you show should compile, though.

new BigDecimal(field, new MathContext(3, RoundingMode.HALF_EVEN))

Re: Cannot Convert from Float to BigDecimal Error: Tried with java syntax new BigDecimal.

Anonymous — Tue, 03 Oct 2017 16:13:17 GMT

Thanks for reply.

Code error is Exception with Type Mistmatch: Cannot convert Float to BigDecimal.

tried our code too but error not resolved.

Request talend team to look into this.

Re: Cannot Convert from Float to BigDecimal Error: Tried with java syntax new BigDecimal.

Anonymous — Tue, 03 Oct 2017 16:23:35 GMT

@mlorber wrote:

tried our code too but error not resolved.

Hi, I think the error is occurring somewhere else in our job (not what you are showing in your screenshot). I was suggesting to look at the code tab to see more specifically where the error is.

Re: Cannot Convert from Float to BigDecimal Error: Tried with java syntax new BigDecimal.

Anonymous — Wed, 04 Oct 2017 08:02:06 GMT

Have you used TypeConvert routine in Talend?

Please try with TypeConvert.Float2BigDecimal(floatvalue) where floatvalue is the value from source and assign the output to Target.

Velu.

Re: Cannot Convert from Float to BigDecimal Error: Tried with java syntax new BigDecimal.

Anonymous — Wed, 04 Oct 2017 10:50:26 GMT

Hi Velu,

Thanks for your reply, I'm getting same Type Mismatch error again no change at all with your expression.

Regards,

Jagadesh

Re: Cannot Convert from Float to BigDecimal Error: Tried with java syntax new BigDecimal.

Anonymous — Thu, 26 Oct 2017 18:58:07 GMT

Try converting with BigDecimal.valueOf(float) to get the BigDecimal value

Regards

Velu

Re: Cannot Convert from Float to BigDecimal Error: Tried with java syntax new BigDecimal.

Anonymous — Fri, 27 Oct 2017 14:56:14 GMT

Hi there,

There is no BigDecimal constructor which takes a Float, although there is one which takes a Double, and Java should automatically promote your Float to a Double when used within the constructor.

You also need to consider what happens if your input value is null. Use a ternary expression to return BigDecimal.ZERO instead, which for math purposes is likely to be what you'll want.

Be aware that converting from a Float to a BigDecimal will almost certainly not give you the exact value you're expecting, due to lack of precision with the floating point data type.

For example, if your input value is 1.23f, then converting to a BigDecimal without specifying the precision will give you the value 1.230000019073486328125, which probably isn't what you want. By adding a suitable MathContext to your BigDecimal constructor (e.g. new BigDecimal(floatIn, new java.math.MathContext(2))) you'll get 1.23.

All that said, as @lli says, it's still quite possible that the error you're seeing is occurring elsewhere in the job, so click "Continue" on the error dialog, make a note of the line number given in the stack trace, then switch to the Code pane and check that the error is actually occurring on the expression within you tMap.

Regards,

Chris