https://community.qlik.com/t5/Talend-Studio/concatenate-Bigdecimals/m-p/2288151#M61667 <A href="https://community.qlik.com/s/feed/0D53p00007vCkflCAC">https://community.talend.com/t5/Design-and-Development/resolved-Error-The-operator-is-undefined-for-the-argument-type-s/m-p/75267</A> Tue, 15 Nov 2016 17:48:36 GMT JR1 2016-11-15T17:48:36Z https://community.qlik.com/t5/Talend-Studio/concatenate-Bigdecimals/m-p/2288150#M61666 <P>Hi,<BR />I am trying to concatenate two big decimal columns and pass it onto target bigdecimal column but it gives me an error as&nbsp;<BR /><I><FONT color="#3366cc">The operator + is undefined type(s)java.math.BigDecimal,java.math.Bigdecimal.</FONT></I><BR />At the start, I have maintained the source columns as String and handled nulls using the code below to bigdecimal but to no avail:<BR /><I><FONT color="#6699ff">(StringHandling.LEN(StringHandling.TRIM(StringHandling.EREPLACE(replaceNulls.column1,"\""," ")))) == 0 ? (BigDecimal)((DecimalFormat)globalMap.get("bdfmt")).parse("0.00") :&nbsp;</FONT></I><I><FONT color="#6699ff">(BigDecimal)((DecimalFormat)globalMap.get("bdfmt")).parse(StringHandling.EREPLACE(replaceNulls.column1</FONT></I><I><FONT color="#6699ff">,"\"","")) .</FONT></I></P> Sat, 16 Nov 2024 10:15:16 GMT https://community.qlik.com/t5/Talend-Studio/concatenate-Bigdecimals/m-p/2288150#M61666 Anonymous 2024-11-16T10:15:16Z https://community.qlik.com/t5/Talend-Studio/concatenate-Bigdecimals/m-p/2288151#M61667 <A href="https://community.qlik.com/s/feed/0D53p00007vCkflCAC">https://community.talend.com/t5/Design-and-Development/resolved-Error-The-operator-is-undefined-for-the-argument-type-s/m-p/75267</A> Tue, 15 Nov 2016 17:48:36 GMT https://community.qlik.com/t5/Talend-Studio/concatenate-Bigdecimals/m-p/2288151#M61667 JR1 2016-11-15T17:48:36Z https://community.qlik.com/t5/Talend-Studio/concatenate-Bigdecimals/m-p/2288152#M61668 Thank you. It worked as expected. Wed, 16 Nov 2016 15:11:33 GMT https://community.qlik.com/t5/Talend-Studio/concatenate-Bigdecimals/m-p/2288152#M61668 Anonymous 2016-11-16T15:11:33Z