topic Re: tmap expression syntax in Talend Studio

tmap expression syntax

Anonymous — Thu, 07 Mar 2019 07:36:39 GMT

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...

Re: tmap expression syntax

manodwhb — Thu, 07 Mar 2019 07:49:41 GMT

@lavan524 ,that hole expression will return a single character ,let think this way you have null as string with that expression will return only n ,if you changed 1 to 3 it will return nul

Re: tmap expression syntax

Anonymous — Thu, 07 Mar 2019 07:50:40 GMT

Hi,

Please try like below.

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

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 🙂

Re: tmap expression syntax

Anonymous — Thu, 07 Mar 2019 07:57:46 GMT

i have tried this way but still getting same output

Re: tmap expression syntax

Anonymous — Thu, 07 Mar 2019 07:59:38 GMT

Hi,

Could you please print the input and output side by side to a tLogrow and share it with us? We would like to see the input data you are passing.

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 🙂

Re: tmap expression syntax

manodwhb — Thu, 07 Mar 2019 08:00:43 GMT

@lavan524 ,do you understand my answer,if not for that column have null values as string which means "null" has took as for that column with your expression returns only one character for "null" data the first character is n,so thats why you see n

Re: tmap expression syntax

Anonymous — Thu, 07 Mar 2019 08:02:30 GMT

Actually i am trying to test expression in tmap test editor ...as per expectation by default value should be null and as per expression out put should be " null " but getting " n "

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

Re: tmap expression syntax

manodwhb — Thu, 07 Mar 2019 08:04:24 GMT

@lavan524 ,if you want null then change this way.

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

Re: tmap expression syntax

Anonymous — Thu, 07 Mar 2019 08:04:57 GMT

@manodwhb has already explained it.

You are trying to insert null as a string "null" or "Null" or "NULL". But as per java, if it has to consider a value as null, it should be empty like a black hole.

You cannot equate it with any value as string.

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 🙂

Re: tmap expression syntax

Anonymous — Thu, 07 Mar 2019 08:09:14 GMT

@lavan524

Or try this way where the code is checking whether you are sending input itself as "null".

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

But the caveat is that sending null as a string is a bad practice.

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 🙂

Re: tmap expression syntax

Anonymous — Thu, 07 Mar 2019 08:09:34 GMT

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

Re: tmap expression syntax

Anonymous — Thu, 07 Mar 2019 08:11:55 GMT

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 🙂