topic Re: tXMLMap Expression Help in Talend Studio

tXMLMap Expression Help

Anonymous — Fri, 04 Dec 2015 13:54:47 GMT

Hi,
this is my input : Mont = 129483948 ( type of Mont is string)
in my out put i need to have this : res =1294839,48 ( type of is BigDecimal )
Thank you for your help.

Re: tXMLMap Expression Help

Anonymous — Fri, 04 Dec 2015 14:03:18 GMT

In your output (I will call it the "RES" column) you need the following. I am assuming the input row is "row1" and the input column is "MONT"...

row1.MONT!=null ? new BigDecimal(row1.MONT) : null

This checks to see that the MONT value is not null and then converts it to a BigDecimal if it is not null. If it is null, it just sets the output column to null.

Re: tXMLMap Expression Help

Anonymous — Fri, 04 Dec 2015 14:54:17 GMT

Thank you for your response, but me i retrive the input from a xsd scheme like this :

So how to do it ?

Re: tXMLMap Expression Help

Anonymous — Fri, 04 Dec 2015 14:58:41 GMT

after adding your expression i get this error :

Re: tXMLMap Expression Help

Anonymous — Fri, 04 Dec 2015 15:07:25 GMT

It looks like you have a non numeric value in your number (maybe a monetary unit?) or the value is an empty string. If it is the non numeric unit, you will need to remove it. If it is an empty string, you need to filter those from being processed.
For example....

row1.MONT!=null && row1.MONT.trim().compareToIgnoreCase("")!=0 ? new BigDecimal(row1.MONT) : null

Re: tXMLMap Expression Help

Anonymous — Fri, 04 Dec 2015 15:49:09 GMT

Thank you it works.
Regards