convert string datatype to boolean datatype

One Star

convert string datatype to boolean datatype

I have requirement where i have to convert a string coming from a database to a boolean datatype in to salesforce.
the  string value are ( 'Y' and 'N' ) from a column in table.....
and my mapping components are 
sql server table--->tmap-->salesforce output component...
which method should i use in tmap expression editor to convert the string 'N' or string 'Y' to boolean datatype for salesforce.
or this needs to be converted by using something else???im new to talend so pls provde the answer in detail

Re: convert string datatype to boolean datatype

Hi Ather,
you can write like this in tMap
databasevalue.equals("Y")?true:false. please try this once

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach


Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.



Introduction to Talend Open Studio for Data Integration.