topic Re: tHMap how to used the function IfThenElse in Talend Studio

tHMap how to used the function IfThenElse

confo_talend — Sat, 16 Nov 2024 04:03:16 GMT

Hi,

I want to transform json to xml and i have in the json file a string column can contain two value : SERVICE or PRODUCT.

So in the component tHMap i want to use the function IfThenElse to put un the xml file true or false :

If ColumnValue=SERVICE then True else False.

The condition don't accept to write a code, it accept just drop/paste !!!!

Thanks.

Re: tHMap how to used the function IfThenElse

Anonymous — Thu, 21 Nov 2019 22:18:42 GMT

Here is an example with a dummy schema that I had on my machine....

Notice I dragged the "EQUAL" method from the Functions menu. I then added my value to the first field and dragged the "CONSTANT" function to the second. I then was able to type "SERVICE" as the "CONSTANT" value. Below you can add your THEN and ELSE options.

Re: tHMap how to used the function IfThenElse

confo_talend — Mon, 25 Nov 2019 15:01:46 GMT

i used this solution but i have always false

i think something else it missing

Re: tHMap how to used the function IfThenElse

Anonymous — Mon, 25 Nov 2019 15:38:55 GMT

You will need to check the data that is being compared. For example, what case is it, does it have spaces after the value, etc

Re: tHMap how to used the function IfThenElse

confo_talend — Tue, 26 Nov 2019 14:58:23 GMT

yes it's a problem of data.

Thanks.