topic Re: Multiply the value of two columns in Talend Studio

Multiply the value of two columns

Anonymous — Thu, 20 Oct 2016 08:22:08 GMT

Hi,
I am very new in talend and this is my first post in forum.
I have created a new job where I have two tables (Oracle) as an input and one table (Oracle) as output.
i would like to multiple the value two columns (price and quantity) and want to transfer the value to a column (sale_value) of output table.
Expression of Sale_Value i have written as table1.price * table2.quantity.
But when running the job getting error message ' The operator * is undefined for the argument type(s) java.math.BigDecimal ...'.
It would be nice if you can let me know the reason for this error.

Thanks with Regards,
JD

Re: Multiply the value of two columns

Anonymous — Thu, 20 Oct 2016 09:02:36 GMT

BigDecimal is a class and not a primitive type. This means that you need to use the class' methods to do this. A tutorial can be found here (https://www.tutorialspoint.com/java/math/bigdecimal_multiply_mc.htm).

Re: Multiply the value of two columns

Anonymous — Thu, 20 Oct 2016 09:35:26 GMT

Thank you very much rhall. it works.

Thanks with Regards,
JD