topic Re: Type mismatch: cannot convert from String to boolean in Talend Studio

Type mismatch: cannot convert from String to boolean

himanshup — Wed, 09 Oct 2024 02:09:56 GMT

Version: 8

Build id: 20240524_0800-patch

Hi,

I have this expression in tMap.

/if the work email is null

row7.EMAIL==null

//or the work email is blank

||StringHandling.BTRIM(row7.EMAIL).isEmpty()==true

//then return empty string

?""

//else return the email string

:StringHandling.DOWNCASE(StringHandling.BTRIM(row7.EMAIL))

I am trying to replace the null vlaue to "" in the EMAIL field.

I am getting the error:

Type mismatch: cannot convert from String to boolean

The EMAIL columns is defines as varchar2(30) in Oracle (source).

Appreciate any suggestions.

Thank you

Re: Type mismatch: cannot convert from String to boolean

marksouzacosta — Wed, 09 Oct 2024 01:44:20 GMT

Hi @himanshup ,

What is your tMap field type? Can you please share screen shots with your Expression and tMap with all fields?

Regards,

Mark Costa

Re: Type mismatch: cannot convert from String to boolean

Shicong_Hong — Wed, 09 Oct 2024 02:21:35 GMT

Hello

I think the error occurs on this expression:

||StringHandling.BTRIM(row7.EMAIL).isEmpty()==true

try to change it to:

row7.EMAIL==null||row7.EMAIL.isEmpty()==true?"":StringHandling.DOWNCASE(StringHandling.BTRIM(row7.EMAIL))

Re: Type mismatch: cannot convert from String to boolean

himanshup — Wed, 09 Oct 2024 14:44:36 GMT

Hi Mark,

here is the screen shot of the fields:

Re: Type mismatch: cannot convert from String to boolean

himanshup — Wed, 09 Oct 2024 14:45:21 GMT

Hello,

That change still gave the same error message.

row7.EMAIL==null||row7.EMAIL.isEmpty()==true?"":StringHandling.DOWNCASE(StringHandling.BTRIM(row7.EMAIL))

Thank you

Re: Type mismatch: cannot convert from String to boolean

Dave_Simo — Wed, 09 Oct 2024 17:26:40 GMT

Hello,

It should rather be put in the mapping of the EMAIL field than in the tMap filter, see screenshot below

Best Regards,

Re: Type mismatch: cannot convert from String to boolean

himanshup — Wed, 09 Oct 2024 17:32:02 GMT

True, Thank you.