topic Re: Multiplication of values in tMap in Talend Studio

Multiplication of values in tMap

Anonymous — Sun, 26 Jan 2020 01:04:02 GMT

Hello Community,

I am pretty new in Talend so this is probably a basic question:

In my If / Else Condition I can´t multiply the two values of column row15.price (Integer) and row15.PLN(Double) in the Expression builder. If I try to test it following Error occurs:

Exception in thread "main" java.lang.Error: Unresolved compilation problem:

row15.currency.equals("PLN") ? row15.price*row15.PLN : "AA"

Re: Multiplication of values in tMap

TRF — Sun, 26 Jan 2020 09:17:15 GMT

For a ternary expression, both parts (if/else) result must have the same datatype.
Try to change "AA" by something like -1.0 to signify the currency wasn't equal to PLN.

Re: Multiplication of values in tMap

Anonymous — Sun, 26 Jan 2020 11:40:31 GMT

Hello TRF,

thank you very much for your answer.

When I change the "(if/else) results" to the same Datatype (e.g. assigning it to one variable) it works but I still can´t do a multiplication because it reads everything as a String. If I build a sum of e.g. 3.9+3.9 = 3.93.89 as you can see in the picture.

How can I check if something equals "PLN" in the currency and then do a proper multiplication of doubles if it does and "else" give back a double:

row15.currency.equals("PLN") ? row15.price*row15.PLN : row15.price

I really appreciate your help. Thank you!

Re: Multiplication of values in tMap

TRF — Sun, 26 Jan 2020 12:14:05 GMT

You need to convert values from string to double:
Double.parseDouble(row15.price)*Double.parseDouble(row15.PLN)