topic Re: talend cannot convert from string to boolean in Talend Studio

talend cannot convert from string to boolean

Anonymous — Mon, 04 Jan 2016 18:12:35 GMT

Hi Team,
I have input field is string and output is also string.

Using this field to write expression (I need to filter data based on this condition) row3.Organization_Name.equals("MM")
and also I tried row3.Organization_Name=="MM"

but it gives error cannot convert string to Boolean. can u please help me with solution

do we have like operator in talen..because I need to handle row3.Organization_Name like"M%"

Re: talend cannot convert from string to boolean

rgagnon — Mon, 04 Jan 2016 20:12:09 GMT

To simulate a LIKE operator, try something like this as a filter :

StringHandling.LEFT(row3.Organization_Name ,1).equals("M")

Re: talend cannot convert from string to boolean

Anonymous — Tue, 05 Jan 2016 10:38:07 GMT

The String class should have all you need.
You can say row3.Organization_Name.startsWith("M")
I'm not sure why your example would give you a String to Boolean error. You definitely cannot use "==" as this will always return false.
And don't forget to always null test first.