Type mismatch: cannot convert from String to boolean

[himanshup]

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

[marksouzacosta]

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

[Shicong_Hong]

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

[himanshup]

Hi Mark,

here is the screen shot of the fields:

[himanshup]

Hello,

That change still gave the same error message.

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

Thank you

[Dave_Simo · Accepted solution]

Hello,

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

Best Regards,

[himanshup · Accepted solution]

True, Thank you.