topic int to bigdecimal in Talend Studio

int to bigdecimal

_AnonymousUser — Tue, 11 Jun 2013 17:22:10 GMT

hello,
i have a process where i need to map int to bigdecimal column.
i have this function Numeric.sequence("TRAB_SEQUENCE",context.last_id,1) in expression builder and type bigdecimal
but i have this error
"type mismatch: cannot convert from integer to bigdecimal"
when changed the type to "int" i had the same error because the output column is Bigdecimal.
how can i fixed that?
thanks in advance
RT

Re: int to bigdecimal

Anonymous — Tue, 11 Jun 2013 17:59:09 GMT

You have to create a BigDecimal value from the value returned by Numeric.sequence, which is an int.
I think this will work:
new BigDecimal(Numeric.sequence("TRAB_SEQUENCE",context.last_id,1))
new creates a variable of type BigDecimal, and it is set to the value returned from your call to sequence.

Re: int to bigdecimal

_AnonymousUser — Tue, 11 Jun 2013 18:37:33 GMT

You have to create a BigDecimal value from the value returned by Numeric.sequence, which is an int.
I think this will work:
new BigDecimal(Numeric.sequence("TRAB_SEQUENCE",context.last_id,1))
new creates a variable of type BigDecimal, and it is set to the value returned from your call to sequence.

you are the Best. thanks a lot
RT