tmap expression syntax

[Anonymous]

i have tried below expression in tmap as per expectation i should get  " null " as output in tmap test editor ..but getting  "n" as output ...could you please clarify this...

[Anonymous]

I just want to clarify one thing .. as per ternary expression 

Condition ? True : False

Relational.ISNULL(row1.S_Name_Indexed__c) || row1.S_Name_Indexed__c.trim().equals("")?null :row1.S_Name_Indexed__c.substring(0,1).toLowerCase()

in my case condition is true and i should get "null" as result but why i am getting  "n" as out put

[Anonymous]

Hi,

   It is because you are sending a string called "null". It is not equal to actual null in Java. But if you are insisting that you would like to send null as String, please try the code in previous post.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂