topic Re: job in Talend Studio

job

Anonymous — Mon, 05 Mar 2018 12:55:19 GMT

Hello All,

Can anyone please help me.my requirement is

1.input data type is decimal.

11.0000---->11.0000

12.123----->12.123

0.000---->this value will not be loaded

0----->this value should not be load in target

I was tried but I get an error i.e cannot convert for int(0) to decimal.

can any one please provide the suggestion and soluton.

thanks

Jesperrekuh — Mon, 05 Mar 2018 18:30:05 GMT

in your mapping just use int -> float which is a decimal

manodwhb — Tue, 06 Mar 2018 05:49:54 GMT

you can use below function to convert bigdecimal.

new BigDecimal(row1.string_column)

manodwhb — Wed, 07 Mar 2018 11:47:20 GMT

did it help you?

Anonymous — Wed, 07 Mar 2018 12:41:20 GMT

THANK YOU GUYS .

For sharing your knowledge.

manodwhb — Wed, 07 Mar 2018 12:48:46 GMT

Please give kudos and click Accept the solution which one is helped.