Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
i used this solution but i have always false
i think something else it missing
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
yes it's a problem of data.
Thanks.