Multiply the value of two columns

[Anonymous]

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

[Anonymous]

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). 

[Anonymous]

Thank you very much rhall. it works.

Thanks with Regards,
JD