topic Re: conversion issue from string to bigdecimal? in Talend Studio

conversion issue from string to bigdecimal?

Anonymous — Sat, 16 Nov 2024 12:23:59 GMT

hi guys,
my input is like tis..
Process_Compliance
-----------------------
N-Apl
3.5
4.3
3.5
N-Apl
4.2
N-Apl

my script in tmap is---->
row2.Process_Compliance.equals("N-Apl")
?BigDecimal.valueOf(0):
new BigDecimal(row2.Process_Compliance);
need output as
Process_Compliance
-----------------------
0
3.5
4.3
3.5
0
4.2
0
when i run my job with above script,i am getting following bug..

xception in component tMap_1
java.lang.NumberFormatException
at java.math.BigDecimal.<init>(Unknown Source)
at java.math.BigDecimal.<init>(Unknown Source)
at

pls let me know any one
thanking u

Re: conversion issue from string to bigdecimal?

Anonymous — Tue, 07 Feb 2012 06:59:08 GMT

Hi
You'd better set the type of this column "String" and type expression in tMap as follow.

row2.Process_Compliance.equals("N-Apl")?"0":row2.Process_Compliance

Regards,
Pedro

Re: conversion issue from string to bigdecimal?

Anonymous — Tue, 07 Feb 2012 07:09:53 GMT

hi pedro,
thanks for given quick reply...,i understood wht u mean.....but my target table field as bigdecimal always....

if that is the case,how we can convert from string to bigdecimal?

pls let me know....

Re: conversion issue from string to bigdecimal?

Anonymous — Tue, 07 Feb 2012 07:18:53 GMT

Hi
Here is another workaround.
Use tReplace component to replace "N-Apl" with "0".
Then use tMap to convert String to BigDecimal.

new BigDecimal(row.ColumnName)                    //row.ColumnName should be String.

Regards,
Pedro

Re: conversion issue from string to bigdecimal?

Anonymous — Tue, 07 Feb 2012 07:58:35 GMT

hi pedro,
i am getting...
Process_Compliance
-----------------------
0.00
0.00
0.00
0.00
0.00
0.00
after i used the baove code,any how...i am getting input as ...
Process_Compliance(Input Column)
-----------------------
N-Apl
3.5
4.3
3.5
N-Avl
4.2
NA
sorry,the above logic is not helpfull,
why can't we decode in tmap & convert from string to bigdecimal????????,can we get that way......any thing...

thanks

Re: conversion issue from string to bigdecimal?

Anonymous — Tue, 07 Feb 2012 08:05:15 GMT

Hi
Here are the screenshots.
Regards,
Pedro

Re: conversion issue from string to bigdecimal?

Anonymous — Tue, 07 Feb 2012 08:20:42 GMT

hi pedro,
my input is different...
tis is my input,
Process_Compliance(Input Column)
-----------------------
N-Apl
3.5
4.3
3.5
N-Avl
4.2
NA
how we can use tReplace tis is the case?

Re: conversion issue from string to bigdecimal?

Anonymous — Tue, 07 Feb 2012 08:29:52 GMT

Hi
You can check "Advanced mode" of tReplace.

"^N.*"

Regards,
Pedro

Re: conversion issue from string to bigdecimal?

Anonymous — Tue, 07 Feb 2012 08:59:39 GMT

it's works fine...

Thank u Pedro.... (Y)

Re: conversion issue from string to bigdecimal?

Anonymous — Wed, 08 Feb 2012 03:45:55 GMT

hi guys,
i am getting following issue with tmap......after i done the above steps...
Exception in component tMap_1
java.lang.NumberFormatException
at java.math.BigDecimal.<init>(Unknown Source)
at java.math.BigDecimal.<init>(Unknown Source)

pls let me know any one wht was the cause?

thank u